Litmus Excel AddIns
Litmus DataHub AddIns

Manage DataHub Queries

6min

You can modify and delete queries in the Litmus DataHub Queries.

Before You Begin

Step 1: Access the Manage DataHub Queries Form

  1. Navigate to the Manage Data Queries section to view a table listing all existing queries. The Litmus DataHub Queries window pop-up appears.

    Document image
    

Step 2: Review the Query Table

You will see a table or list displaying your available queries. Refer to the following actions you can take from this page:

Document image


Action

Details

[1] Queries

Shows the total number of defined queries.

[2] Query Name

Displays the defined query name. Click on the query name to open the query edit dialog box.

[3] Connection Name

Displays the defined connection name.

[4] Query

Displays the details of your query.

[5]Created By

Shows the creator of the query, which is useful in multi-user scenarios.

[6] Actions

  • View: Select the information (eye) icon to open the query edit dialog box.
  • Delete: This option (bucket icon) deletes the selected query. Note: Deleting a query also deletes the associated sheet. Ensure that any data you require is not stored on the same sheet as the query.

Step 3: Edit a Query

To enter the edit mode, you have two options: click on the [2] Query Name or select the [6] Actions: View to open the query details.

  • In edit mode, make necessary changes to the query parameters. For example: to sort data in descending order, adjust the sort parameter accordingly.
  • After modifications, click Save to apply the updates.
  • The system will confirm that the query has been updated.

Note: The changes are immediately reflected in the query list.

Document image


Important: If a query is using a connection, the Delete option is disabled for that connection.

This prevents accidental deletion of queries tied to active connections.

Document image