*Query Builder

The Query Builder is a fundamental tool within the Admin Platform, primarily used to construct the underlying data queries that power reports.

Queries define what data will be retrieved and how it will be organized for display. You can access the Query Builder under settings within the VU Admin Platform, specifically listed under the 'Reporting' section.

When you go to the Query Builder, you can either use existing queries or add a new query and build it from scratch.

Starting a Query:

To start a new one, you click on Settings > Query Builders > Add New.

Only users with Administrator permissions can add the query builders.

Creating a New Query Builder

To add a query builder:

1. Enter the details provided below as a reference:

• Name: Give your query a specific, memorable name. You'll need to find it later.

• Data Source: Click Add Table to choose where your data comes from (e.g., the Orders table).

• Columns: Click Add Column to pick the specific fields you want in your report (e.g., company_id, status). Add as many as you need.

• Filters: This is where you can get really specific. Click Add Filter to narrow the results. For example, to only see data for a single company, you could set a filter where company_id = 12345. You can stack multiple filters using AND/OR logic by grouping them.

• Rollup: Check this box if you want to aggregate data. It's perfect for getting counts or sums instead of a long list of individual rows.

• Sorting and Limiting: You can set a default sort order (Order By) and cap the number of results (Limit) to keep your reports clean and fast.

1. Once you're done with it, hit Save. The query builder will be successfully created.

Edit Query Builder

To edit a query builder, select the query and update the values.

Delete Query Builder

To delete a query builder, select the query builder and click Delete.

The query builder gets deleted after confirmation.