fabrik_list_filter_all_X_com_fabrik_X ... AND other search terms ?

[sn00ze]

Hello,

I am filtering via URL with multiple parameters.
I want one of the parameters to be: fabrik_list_filter_all_X_com_fabrik_X
I want to logical AND a couple of other search parameters with the fabrik_list_filter_all_X_com_fabrik_X

eg.
/index.php?option=com_fabrik&view=list&listid=5&fabrikdebug=1&resetfilters=1&fabrik_list_filter_all_5_com_fabrik_5=Belconnen&new_entry___category[value]=10&new_entry___category[join]=AND

perhaps I have the syntax wrong?
the [join]=AND doesn't do it.... the result (and SQL) is an OR of the search terms.

Thanks for any help!

 

[sn00ze]

I've made some progress...
By editing my list (that's being searched) -> Details -> Filters tab-> Extended search all = YES

Now the SQL query is AND ing the search terms...
but...now this error:

#1271 - Illegal mix of collations for operation 'match'

the SQL that's the problem is:
FROM `new_entry`
WHERE ( ( (`new_entry`.`category` = '10' OR `new_entry`.`category` LIKE '[\"10\"%' OR `new_entry`.`category` LIKE '%\"10\"%' OR `new_entry`.`category` LIKE '%\"10\"]') AND MATCH(`new_entry`.`business_name`, `new_entry`.`category`, `new_entry`.`suburb_city`, `new_entry`.`meals_served`, `new_entry`.`type_of_cuisine`, `new_entry`.`other1`) against ('Belconnen*' IN BOOLEAN MODE)) ) LIMIT 0, 5

PS: using fabrik 3.1rc2

 

[rob]

ensure that you only have fields in your search all that are text/varchar fields (you can choose those by editing the list and clicking on the filters tab and then the elements button), if you have say an integer field in there then the the illegal collation error occurs.

For the syntax on the general querystring filters the wiki has been recently updated:
http://fabrikar.com/forums/index.php?wiki/filtering-lists-tables/#filtering-via-the-url

 

[sn00ze]

resolved in this thread:
http://fabrikar.com/forums/index.ph...ations-for-operation-match.36623/#post-183959