riq-saved query

[rj5316]

Hi,

how does one delete a saved query in the riq or the rates short cut in the ask otm task bar....

rgds--

[bmj_23]

Re: riq-saved query

Hi - I ran in to this same issue a while ago. Whilst you would expect that those saved queries would be stored on the normal saved_query table, they are actually stored on user_appdata. Therefore, as far as I remember, the only way to remove those saved queries in the RIQ drop down list is via SQL.

If you use the following select statement, you should be able to identify the data that appears in the RIQ drop down:

select GL_USER_GID, KEY FROM USER_APPDATA WHERE KEY LIKE '%RIQ%'

From there, you will need to delete them manually via SQL; I dont believe there is a way of doing that via the UI.

Re-post if you are still having issues with this.