Bug filtering for dropdown element

[myfatebiz]

Hi,

I just found bugging filtering for dropdown element. It show No records.

Element type : dropdown

Filter type for dropdown element :

• Field : Working
• Dropdown : Working
• Range : Working
• Auto-complete : Working
• Checkbox : Not Working (No records)
• Multi-select list : Not Working (No records)

Please anyone confirm. Thanks.

Regards,
MyFateBiz

 

[troester]

Confirmed.

With filter = checkbox, exact match
table:mergeJoinedData get ids is looking like
WHERE (`atestmk13`.`dropdown` LIKE '%\"1\"%' ) (one box checked)
WHERE ( `atestmk13`.`dropdown` LIKE '%\"0\"%' AND`atestmk13`.`dropdown` LIKE '%\"1\"%' ) (two boxes checked)

So it seems checkbox/multiselect filters is only working if it's a mutliselect dropdown (I didn't test).

A standard non-multiselect dropdown should be handled like a dbjoin, with a condition
WHERE ( `atestmk13`.`dropdown`IN ('0','1') ) (two boxes checked)

 

[rob]

Im not seeing that - for me each selected value is using OR and not AND.
What other options do you have, can you post screen shots of the element settings and its filter settings?
thx
Rob

 

[troester]

Hi Rob, this is Fabrik3.0 (it's ok in 3.1)
Dropdown element, no multiselect
Filter = checkbox

 

[rob]

Sorry, sorry sorry! I missed that - indeed in 3.0.x it wasn't working.
I've back ported the working code from 3.1.x and updated github with this commit :
https://github.com/Fabrik/fabrik/commit/d7a004a14b1260183de5d8948a26ca114759e284
Testing the filter now seems to work ok, please update and let me know if its working for you

-Rob

 

[myfatebiz]

Tested and confirmed this problem has be fixed with latest github. Thanks.