Default Filtering Options

Q&A
, ,
1

I am having trouble setting a filter group that allows returning a result where either of the options are selected.

Currently I have the filter group selected with an or condition. Is it possible to change the default filter. I want to have the default filter option setup to be select all values except null values but I am struggling to have this configuration applied.

I have tried using a custom filter list with exclude nulls option but that requires me to specify all of the values which there is a massive list of which is not feasible.

Do you have any advice or options for how this can be achieved?

2

how about using custom filter and using “does not contain”?

And put some value which doesn’t exists in the field. Like following image

image
image246×706 21.6 KB

3

Hi @firzen23,

Just checking in since this thread hasn’t received a response in a while. Was royyung’s suggestion helpful or were you able to find a workaround yourself in the meantime? If we do not hear back within the next 3 business days, I’ll go ahead and close/archive this topic.

Thanks!

4

Sorry for the delay in my response I was put on other projects and back looking at this.

I have tried the suggestion but that creates the control as a text field I still want to keep the control as a drop down multi select box I just want to exclude the nulls on initial setup.

This is because I have two drop downs that are in an or condition. The user can select which packs or plans they want to view. The issue is that many people have a plan and no pack and vice versa so when they select the plans to view its doesn’t filter right away the then have to deselect the null pack for it to be applied.

This is creating a really poor user experience and I have tried many different options with no luck.

5

Here is a quick arena demo I put together while this data set is super cut down I can’t simply select empty string on the base filter as there are millions of different pack/plan options and I get the to many values to load message when trying to set the base filters on it.

Pack Plan Testing

1 Like
6

Hi @firzen23,

As it’s been awhile since last communication took place on this thread; checking in to see if you’re still working on this or if you’ve found a work around in the interim?

If still working on this; and regarding your initial filter, have you tried setting up as a parameter instead and setting the default value to ‘ALL_VALUES’ if you want it to be setup as select all?