Filtered research and repeating group showing results

[ed727]

Hi, see here for how to write the intersect with expression so that if nothing is selected in the input, all results are shown.

Advanced filter - multi constraints context

To add to this thread… there’s a question here about how to have the advanced filter intersect method return all results when nothing is selected. A solution is to have the filter say the following… input list’s value: count is 0 or input list’s value intersect with…" In this example “input list” is whatever list you are comparing with the list in the datatype.

Regarding having multiple inputs…

• If anything isn’t a “list to list” search requiring the advanced filter, put it in your regular searchbox and check ignore empty constraints. This will run server side and is faster.
• If you have multiple “list to list” searches, if you add each one in their own constraint within the list filter search box (ie “Add a new constraint”), then they will act as an “and” between them.

Note also that some people set these types of filters to trigger off a workflow, where each search constraint is its own step in the workflow, but I have stayed away from that route because I haven’t seen anyone explain the upside vs. the above simpler method.