Project

General

Profile

Actions
Copy link

Bug #6706

closed

Exclude subtypes parameters do not work

Added by krileon over 7 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
krileon
Target version:
6.1.0
Start date:
27 July 2017
Due date:
% Done:

100%

Estimated time:

Description

The subtype parameter contains type and subtype as "8,CB Language Plugins" for example. This is directly used in a NOT IN query where statement against subtype. This of course fails since it also contains type. A test against concat of type and subtype should fix this. Example as follows.

CONCAT_WS( ',', `type`, `subtype` ) NOT IN ( '8,CB Language Plugins', '8,CB Groupjive' )

Note this can't apply for module usages as those exclude params are just text fields where a comma separated list is supplied.

Actions
Copy link

Also available in: Atom PDF