In webview Query - allow multiple queries to be merged at the same time
Some of our queries are very complex and each one contains tens of thousands of records. These have to be merged together two at a time to get a file for a final report. Let's say you have 6 queries named A, B, C, D, E, F, and you want to merge them using the 'OR' operator. This currently requires 5 separate merges: (A or B), (C or D), (E or F), (AB or CD), (ABCD or EF). This process takes a long time to build and can be confusing to keep track of what has been merged and what still needs to get merged. It would be much more efficient if we could create a list of queries to be merged and just let it run.
-
Lindy Kingins
- Feb 25 2025
- Reviewed: Voting Open
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- +131
Related ideas
Voting for tasks to be made available in web view when these tasks are already available in database view is a great indication that Blackbaud should not sunset db view UNTIL all features in db view are available in web view. It is nuts that we have to vote on things we already can do in db view.
Allow multiple queries to be merged in the web view at the same time.
Please move full functionality of query list to web view. We create queries and add/exclude other queries to build mail/email lists on a daily basis! It is a critical function! Merge queries in constituent lists does not do what we need it to do.
At the moment I have been simply doing this in a spreadsheet of each query result and then using remove duplicates to save the difficulty of doing it in query but it would be amazing if this was something that could just be done in query
I have been hoping this would change in webview. It gets extremely confusing having to run so many merges and updating each one before the other as Lindy expressed. This is a definite need, not a want request.