Hello, I’d like to display in a schedule only those users who have the “administrator” and “monitor” roles, and not the rest. I’ve tried to do this but it doesn’t work! Does anyone have a solution for setting “role = administrator AND monitor”? Thanks ! [image] [image]

[image] How to set OR not AND in a repeating group search App Organization As you know, multiple constraints in a Search are logically ANDed together. There are multiple ways to accomplish OR constraints: While what others say above is true – you can do a :filter operat…

Use :merged with (Do a search = moniteur:merged with Do a serch = administrateur)

[image] rayanerachid91212: I’d like to display in a schedule only those users who have the “administrator” and “monitor” roles, and not the rest. I’ve tried to do this but it doesn’t work! Does anyone have a solution for setting “role = administrator AND monitor”? Thanks ! If that’s what you’…

Thanks for your help guys. I tried to do this but it gives me this :confused: [image] [image] [image]

The option is not available :confused: And yes, I want to display the “monitor” and “administrator” employees in a schedule. Each employee has only one role of course, not both at the same time. [image]

So you ned to merge the two searches (as @Jici says)

[image] rayanerachid91212: Thanks for your help guys. I tried to do this but it gives me this :confused: in your case :merged with operator should be used in data source, not in constraints: [Screenshot 2023-06-07 at 18.38.46]

Help with constraints

Need help

artemzheg June 7, 2023, 3:02pm 2

Topic		Replies	Views
When searching, is there an 'OR' in constraints? Questions	3	5078	May 30, 2018
Or constraints instead of And Need help	5	115	July 24, 2024
Is this an and or or function? Database	5	1097	May 15, 2023
Filter with and - or - and does not work Need help	2	2186	February 27, 2018
Constraint for 2 or more option sets in Repeating Group Database	2	939	February 4, 2022

Help with constraints

Related topics