Logic of filters built on user submitted values

  • 1
  • Question
  • Updated 3 years ago
  • Answered
Hello,
I would like to filter candidates to worky by few fields. Regarding to (https://community.skuidify.com/skuid/topics/filter_table_using_or_a_value_entered_by_the_user) I create this action framework and it works but.....

When I add more than 3 conditions in grouping logic with 'and' (1 and 2 and 3 and 4) searching is not working. Is there any limitations how many conditions could be grouped?

Another question is: When I have 3 filelds that according to them I would like to filter and I set Values on 1 and 2, and 3 is non selected, Skuid search candiates that have matching values in 1 and 2 and empty value in 3. I would like to search by matching values in 1 and 2 and any value (empty and any value) in 3 is it possible?


Best regards
Pawel
Photo of Pawel

Pawel

  • 240 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Pawel

Pawel

  • 240 Points 100 badge 2x thumb
Hello,
could someone help me?
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Pawel,

There is not a limit to the number of conditions you can string together.

It sounds like you'll need some javascript to check if there are values in your fields when you filter.

Also, it might be a better solution to launch the filtering from a model action that happens as soon as one of your filter fields is changed, rather than waiting for the user to hit a 'filter' button.
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Pawel. 

We created an improved version of this "user submitted" input page.  This page allows for more than one field to be used, and ignores blank fields rather than only returning records where that field is specifically blank. 

Look here for XML for this updated sample page.  

https://github.com/skuidify/SamplePages/blob/master/ActionRecipies/Arbitrary%20Filters%20-%20Model%2...