How to Use Multi Query in Advanced Query – BridgeWorks Help Center

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

Article Goal

This article explains how to use the Multi Query feature within Advanced Query in VDM to return multiple result sets from a single view execution.

Why Use Advanced Query Multi Query?

Multi Select lets you:

Combine multiple queries into one view
Return separate result sets for each query
Simplify complex data retrieval with advanced logic

🧠 Ideal for users who need to fetch related but separate datasets in one go.

Example Multi Select Statements:

Video Tutorial:

Not Yet Available

Steps To Create a Multi Query Advanced Query View.

1: Open VDM: Launch the VDM application on your system.

2: Open Advanced Query: Click on the Advanced Query tab from the toolbar.

🛠️ This opens the editor where you can enter SQL statements.

3: Enter Your First Query: Type or paste your first SQL query into the query editor.

💡 This is the first result set that VDM will return when the view is executed.

4: Enter the Separator: After the first query, add the splitter ;; (double semicolon).

💡 The splitter tells VDM where one query ends and the next begins.

⚙️ To use a custom separator, click here to change the Splitter Value.

5: Enter Your Second Query: After the separator, type or paste your second SQL query.

🔄 Repeat this structure for additional queries, using ;; to separate each one.

💡 If you are using a custom separator, enter that instead of the default.

6: Run the View and Verify Results: Click Run to execute the queries and check the result sets. Then save your View.

🔍 Each query result will appear in a drop down menu on the Data Grid.

⚠️ Make sure each result set is named properly if you plan to reference them in Visualize or Finished Reports.

Article Summary

This article explains how to use the Multi Query functionality in VDM’s Advanced Query feature to run multiple queries within a single view. It guides users through setting up each query, using the correct separator (;; by default), and verifying output across multiple result sets. Useful for advanced reporting scenarios that require combined datasets.

What’s Next?

Once you've confirmed the result sets:

Make sure to save the view to retain your multi-query configuration.
Consider naming your result sets using a Multi Query Name Splitter for easier reference.