Thread: riq-saved query
View Single Post
  #2 (permalink)  
Old December 14th, 2007, 18:09
bmj_23 bmj_23 is offline
Senior Member and Blogger
 
Join Date: May 2007
Posts: 170
Thanks: 4
Thanked 31 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
bmj_23 will become famous soon enough
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.
Reply With Quote