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
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- +114
Related ideas
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.