You have set up some Select statements and need to locate them?

Scenario

In your Data Connection you’ve created some ‘Select’ statements and now you need to locate them. There’s a couple of ways you can do this:

Method 1

If you don’t have too many tables in your Data Connection, you might be able to locate your ‘Select’ statements quickly by clicking Dashboard Configuration > Data Connections. Select the Data Connection that you want to search on the left-hand side and then click the header of one of the tables.

Click the Objects tab and you should be able to quickly see any ‘Select’ statements that have been created.

This method is a quick solution when you don’t have many tables. If your Data Connection contains a number of tables you may find it quicker to use method 2.

Method 2

In the following example, we created a table on the Dashboard that will help us locate certain ‘Select’ statements - in this example, we’re looking for Case statements.

We added the following columns to our table:

  • Data Source Name

  • Table Name

  • Column Display Name

  • Column Select

In order to only display the Case statements, we added a filter.

The resulting table on the Dashboard will help to quickly locate where these statements exist.