Allow multiple parentheses in a row in query criteria.
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)
-
Guest
- Apr 23 2015
Related ideas
11 years later and still no progress on this feature! This seems super basic, and it would be so incredibly useful. Blackbaud, please make your query system more robust.
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.