Saving, Updating, and Re-Using Queries
If you have set up a query in either a Usage, Billing, or Prepayment 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 a 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. You can follow the same procedure for Billing or Prepayments queries.
Saving Queries
To save a query:
1. Select Metering>Usage data explorer.
2. Use the Usage query builder to configure a query, perform the 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 Metering>Usage data explorer.
2. Use the Usage query builder to configure a query, perform the 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 Metering>Usage data explorer.
2. In the Usage 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 Usage query builder. The query is loaded and the query is automatically performed to return data for review.
Next: Exporting Query Results
Additional Support
Login to the Support portal for additional help and to send questions to our Support team.