rob
Administrator
I can't replicate this one.
Here's my test query:
which generates this where statement (I'm testing using fabrikdebug=1 in the query)
using the list nav to go to the next page the URL is:
and the where query is
The order of the filters has changed, but the query results should be the same as the OR and "group by" options are still respected.
Here's my test query:
Code:
http://localhost:81/fabrik31x/public_html/index.php/test-list?&resetfilters=1&fabrikdebug=1&test___country_id_raw[value]=1&test___country_id_raw[join]=or&test___region_id_raw[value]=2&test___region_id_raw[join]=or&test___region_id_raw[grouped_to_previous]=1&test___sex=male&test___button=
which generates this where statement (I'm testing using fabrikdebug=1 in the query)
Code:
WHERE ( ( `test`.`country_id` = '1' or `test`.`region_id` = '2') AND (`test`.`sex` = 'male' OR `test`.`sex` LIKE '[\"male\"%' OR `test`.`sex` LIKE '%\"male\"%' OR `test`.`sex` LIKE '%\"male\"]') AND `test`.`button` = '' ) ORDER BY `test`.`label` DESC
using the list nav to go to the next page the URL is:
Code:
http://localhost:81/fabrik31x/public_html/index.php/test-list?resetfilters=0&fabrikdebug=1&clearordering=0&clearfilters=0
Code:
WHERE ( `test`.`button` = '' AND ( `test`.`country_id` = '1' or `test`.`region_id` = '2') AND (`test`.`sex` = 'male' OR `test`.`sex` LIKE '[\"male\"%' OR `test`.`sex` LIKE '%\"male\"%' OR `test`.`sex` LIKE '%\"male\"]') )
The order of the filters has changed, but the query results should be the same as the OR and "group by" options are still respected.