I am trying to locate Select statements in my database, how can I be sure I have found them all?

Scenario

You followed our instructions in our document about locating ‘Select’ statements but how can be sure you found every single statement? What if some users created these statements in UPPER case and some used sentence case or even lower case? Databases are case sensitive so if this is the case your resulting table will only show some of the results.

Solution

We could make a quick change to our ‘Column Select’ object in the Data Connection that will convert everything to a particular case and therefore make it easier for us to ensure we’re finding every instance of a ‘Select’ statement.

In Dashboard Configuration > Data Connections select the relevant Data Connection on the left-hand side. On the Objects tab, locate the ‘Column Select’ object and change it to UPPER(COLS.COLUMN_NAME).

Open

Remember to click the ‘Save’ icon and when you return to the dashboard, refresh it and you’ll find all the required ‘Select’ statements regardless of how they’ve been entered in the Data Connection.