Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

.Net Search (A or B) and C

Anonymous

.Net Search (A or B) and C

Anonymous
Not applicable

Trying to create a search that would do an 'OR' condition on a group with an additional 'AND' condition outside the group, i.e.: (A OR B) AND C.

 

Because the conditions in a group are joined with 'AND' and not 'OR', I can do this by creating 2 groups (A AND B) OR (A AND C) but this quickly become dirty when having more complex conditions for instance:

 

(A OR B) AND (C OR D) would have to be written (A AND C) OR (A AND D) OR (B AND C) OR (B AND D), and you can see how many conditions that creates.

 

Is there a way to make a group of 'OR' conditions?

0 Likes
Reply
424 Views
1 Reply
Reply (1)

Anonymous
Not applicable

No luck?

 

Ended up doing the (A and B) or (A and C) pattern. The search was still reasonably fast with 40 or so conditions, just a bit dirty.

 

0 Likes