Cannot see previously stored SQL Queries

Version 1

    Details

    Cannot see previously stored SQL Queries


     


    Resolution

    [RESOLUTION]

    1. Tools >> SQL Queries
    2. The user must be selected who originally stored the SQL Queries (SQL queries are tied to a user name and cannot be stored as (public) SQL Queries)


    3. Verify in the SQL Queries drop down that the expected SQL queries are available 




    Additional Information:
    If the user is not sure under which user the desired SQL Query was stored the following SQL query will provide a List of available SQL Queries ordered by user.

    SELECT * FROM FILTERS WHERE RECTYPE  = 'Q' ORDER BY USERID, NAME ASC