Anyone has an example with pictures/or code of Edit User Filter where the Filter

Hi mjmallet, We can try to create the User Filter of type "Expression" and then use the a!facet, a!facetOption in order to use the a!queryFilter.

@mjmallet, if you are looking at generating the filter options dynamically, as per my understanding that is not possible. we can add one facet option which will exclude all the listed ones.. i mean, like "other" and operator "not in"

so that means if I have 100 departments I have to create 100 filter options, is that correct?

Starting in 7.11, user filters can be built using an expression. See the "Expression User Filters" section here:
forum.appian.com/.../Record_Design.html

So if you could create a rule that queries your table and creates a filter option for each row.

I have 7.10, so technically I have to list all my departments one by one right?

Correct. You can't create the filters dynamically until 7.11.

@mjmallet That's not completely true. To the best of my knowledge, capability of adding filters dynamically depends on the source of Record Type. For Process Model and Service Backed, it's static and as said by you in your last comment(and also until 7.11 as specified by @Tyler Criste), you need to add all the 100 options.

If you shift your implementation to Service Backed records(I believe it's slightly time consuming), then you would be able to configure the Default Filters and User Filters dynamically, that is based on an expression.

I guess I will have to try that Service Backed records and compare it with the Entity Backed Record that I currently have to see how it compares. (or if lucky upgrade to 7.11 very soon) :)

Just to add some more info from a design perspective, its not ideal for the user to have to look through a list of 100 filter options. So, if you have so many options that it is a problem to create the filter itself, it may be worth reconsidering the design since it could also be a problem for the end user.

@mjmallet There was a typo in my previous comment here. It wasn't 'For Process Model and Service Backed', it should be 'For Process Model and Entity Backed'.