otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Rating Configuring and troubleshooting Rating and RIQ in OTM / G-Log.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old December 14th, 2007, 12:11
Member
 
Join Date: May 2007
Posts: 89
Thanks: 16
Thanked 1 Time in 1 Post
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
rj5316 is on a distinguished road
riq-saved query

Hi,

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

rgds--
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old December 14th, 2007, 17:09
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
stored query nikesh mohanlal Branding, Screen Sets, XSL/CSS and Translations 1 March 14th, 2008 21:39
saved query nikesh mohanlal Database Administration 0 February 28th, 2008 13:38
OTM 5.5: VPD Query Performance - Improvements ianlo Performance, Scalability and HA 10 December 4th, 2007 00:24
[INSTRUCTIONS] Testing VPD Query Performance chrisplough Database Administration 3 October 12th, 2007 14:47
Time Based Milestone Query bfolan Workflow 0 August 24th, 2007 18:21



All times are GMT. The time now is 12:49.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37