For example, if we want to find constituents who fit criterion A, who also either fit B and C, OR they fit one of D or E, then we should be able to write:
A
AND ((B
AND C)
OR (D
OR E))
As it is we have to use work-arounds like adding a parenthesis before A, then coming up with another criterion to add to the end of the string, just to close out the initial parenthesis, like the example below. But sometimes there isn't a good extra criterion.
(A
AND (B
AND C)
OR (D
OR E)
AND F)
Sorry, scratch that. This query criteria issue is still a problem in 2024 and the work around listed above does not return expected results. There's also not an alternative to queries in the NXT view, so DB view is still only option.
My suggested alternative is a merge query of the two OR scenarios in separate queries.
Thanks for including a secondary method. Helpful!
http://rediscovery.uservoice.com/forums/137015-raiser-s-edge-discovery-topics/suggestions/6273232-allow-multiple-parentheses-in-queries
I agree, but we would get more votes if we merged these suggestions.