How do you create an "or" filter type?

Questions
1

I have multiple user types. I am trying to create a repeating group of all the Admins and Super Admins. If I do the data source filter and select both I end up with an “AND” function and it shows no one.

How do I do an “OR” type filter on the same data point?

2

if they,ve got the text “Admin” common in their roles, u can use “role contains Admin” instead of =sign

1 Like
3
  • “Do a search for User’s”
  • If you have data for their “Status” (admin or super admin) then add a condition that states "Status = “Admin” OR “Super Admin”

image
image730×377 17.5 KB

1 Like
4

It is a User Type. Does this change anything?

It never comes up with “Or”

5

This seems to function like an “AND”

6

Try copying how I’ve done it here

image
image730×377 17.5 KB

1 Like
7

There isn’t a “contains” option.

8

How are you trying to do it then? You’re trying to show all users and then their status or only admins and super admins in the list?

9

Hi there, @timlcooley… you can accomplish what you have described by either using an advanced filter (which could be slow because the filtering happens on the client side) or you can use the :merged with operator to merge two searches (one for users who are Admins and one for users who are Super Admins) together.

Hope this helps.

Best…
Mike

1 Like
10

TinyTake_18-10-2021-11-39-45
TinyTake_18-10-2021-11-39-451395×899 70.2 KB

This is how I started, but it doesn’t return anything.

11

Are you able to share an editor link for this?

The difference between my version and your version appears to be that you’ve entered the “User Type” as a Dynamic field where as mine is simply as text.

Are “User Types” a set of data as well in your application or is it merely a text field on your user?

12

Awesome! The :merged worked perfect!!

2 Likes
13

Yes they are a Option Set