I would like to run a filter on a datagrid conditional on a box being checked. (i.e.: Show expired items only if box is checked). I can get the filter to work fine if I manually toggle the conditional grouping on and off. However, once I link it to the check box with a if then statement if I click the box nothing happens, but if I then refresh the filter is applied. I have other filters that work just fine but do not use the conditional group. Will changing the conditional group not automatically filter the datagrid like other filters?
Hey @jreinagel 
Depends on where you put that filter 
There are several places where you can do that, including:
- At the collection level
- At a repeated list level (formula)
Each of them having pros and cons.
In your case, I believe you are applying the filter at the collection level. If you do that, everytime you modify the filter, you’ll need to retrigger a collection fetch using the workflow action Fetch collection.
Actually I am running the filter at the collection level when I bind the data. I use the filter and then select Conditional group which you can toggle on and off. However, if I do it programmatically it does not update the data in the table. Unlike if you just use a straight filter where X=Y it works in real time.
Yes, that’s because you’ll need to refetch the collection if the filter changes (in your case, if your variable bound to a value in the filters changes).
When you are modifying the filters in the collection settings, it refetches the collection.
Got it. I understand now. Thanks!
1 Like