Filtering with multiple queries on the same column

119 Posts

[email protected] Reply #1, 11 years, 2 months ago

Hi,

I'm building a filter which will search on a column which gets its data from a multiselect TV. Because the JSON in the filter has to be decoded, any duplicate keys are overwritten, so I can't set multiple OR conditions on the same column. My snippet which produces the JSON is:

$output= '{"category:LIKE":"%||'.$cat.'","OR:category:LIKE":"'.$cat.'||%","OR:category:LIKE":"%||'.$cat.'||%","OR:category:=":"'.$cat.'"}';

When processed, this ends up in this array:

    [category:LIKE] => %||1
    [OR:category:LIKE] => %||1||%
    [OR:category:=] => 1

Is there any way to end up with all the criteria in an array or am I going to have to hack the MIGX getlist processor?

This question has been answered by [email protected]. See the first response.

Studio Republic
http://www.studiorepublic.com
0845 226 3205
@christodhunter

discuss.answer

119 Posts

[email protected] Reply #2, 11 years, 2 months ago

Figured it out - use capitals. The query is non case-sensitive but the fromJson function is, so this works fine:

$output= '{"category:LIKE":"%||'.$cat.'","OR:category:LIKE":"'.$cat.'||%","OR:Category:LIKE":"%||'.$cat.'||%","OR:category:=":"'.$cat.'"}';

Studio Republic
http://www.studiorepublic.com
0845 226 3205
@christodhunter

5,888 Posts

Bruno17 Reply #3, 11 years, 2 months ago

you can also try:

$c->where("CONCAT('||',category,'||') LIKE '%||" . $cat . "||%'", xPDOQuery::SQL_AND);

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

Answered Filtering with multiple queries on the same column