Skip to main content
February 2, 2021
Question

User filter based on multiple fields

  • February 2, 2021
  • 14 replies
  • 0 views

Hi,

I'm trying to create a user filter in a record that filters a combination of 2 fields. I've tried to use a!queryLogicalExpression() inside a!recordFilterListOption() for the filter and didn't work.

Is there any other way to do this? My other option is to create an interface with this filter but i think it would be better to have it as a user filter in the record.

Thanks,

Ignacio

14 replies

davel001150
February 4, 2021

One possible way you could do it is to create a local variable of partially filtered users.  Have that update whenever the first filter is applied.  Then, create another local variable of fully filtered users that works by applying the second filter to the partially filtered list local variable.  It would be updated when either the second filter changes, or the users in the first local variable change.

February 9, 2021

I can't do that in a user filter

August 1, 2024

hello [mention:d04a819d11fe4e57903c6d01edc175fb:e9ed411860ed4f2ba0265705b8793d05] did you get solution for this issue? I am also looking for the solution. We are using 22.4 Version. Please let me know how you resolved this issue with default user filters and without using customize filters.

rajnis1428
November 20, 2024

Hello [mention:d04a819d11fe4e57903c6d01edc175fb:e9ed411860ed4f2ba0265705b8793d05]  and Teams,

I am also looking for the same solution. Please let me know how you resolved this issue with default user filters. Please reply as soon as possible.

ignacioa0620
November 20, 2024

Hi, that issue was from 4 years ago, so I don´t remember how (or if) it was solved at that time.

The good thing is that now you can configure Custom Record Fields with any calculation and filter based on that new field

rajnis1428
November 29, 2024

Thank you for your reply, issue is resolved