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
  • Attach files
      Drop here to upload