Saving, Updating, and Re-Using Queries

If you have set up a query in Query Builder and expect to use it again, you can:

  • Save the query for re-use.

  • Update a saved query with the details of the current query.

  • Re-load a saved query into Query Builder.

For some Query Builders, pre-configured Standard Queries are available, such as the Month-on-month report Billing Query. You can use the Standard Queries button in the same way as the Saved Queries button to load these pre-configured Queries.

Note: This topic explains how to save, update, and re-use queries in the context of Usage queries. How to do this for Billing and Prepayments queries is the same.

Saving Queries

To save a query:

1. Select Data Explorer. The Data Explorer opens with the Usage tab selected.

2. In the Query Builder, configure the query, perform a query, and review the returned data.

3. If you expect to want to perform the same query at a later date, select Save Query. A popup appears and the default action selected on the popup is to Save a new query.

4. Enter a Query name and select Save Query. The popup closes and your query is saved.

Updating Saved Queries

To update a saved query:

1. Select Data Explorer. The Data Explorer opens with the Usage tab selected.

2. In the Query Builder, configure the query, perform a query, and review the returned data.

3. If you expect to want to perform the query at a later date, and want to update a query you've previously saved with the details of the current query, select Save Query. A popup appears and the default action selected on the popup is to Save a new query.

4. Select Update an existing query. The popup adjusts.

5. Select a previously Saved query to update. The Query name field adjusts to show the selected saved query to be updated and to be saved under the same Query name.

  • If you want use the same name when updating, select Update Query. The popup closes and the updated query is saved under the same name.

  • If you want to update the saved query under a different name, enter a new Query name and select Update Query. The popup closes and the updated query is saved under the new name.

Re-Loading Saved Queries

To re-load a saved query into Query Builder:

1. Select Data Explorer. The Data Explorer opens with the Usage tab selected.

2. In the Query Builder, select Saved Queries. A popup appears and lists saved Usage queries.

3. Select Load query for the query you want to load into Query Builder. The query is loaded and the query is automatically performed to return data into the Data Explorer tables.

Next: Exporting Query Results



Additional Support

Login to the Support portal for additional help and to send questions to our Support team.