otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
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
Senior Member
 
Join Date: May 2007
Posts: 146
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 16
Thanked 5 Times in 5 Posts
Rep Power: 3
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: 200
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 4
Thanked 36 Times in 35 Posts
Rep Power: 3
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

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
how to run export from optimized saved query? i2p0 Execution 3 August 20th, 2009 08:27
Saved Query rj5316 Workflow and Agents 3 June 18th, 2009 14:59
Integration saved Queries njoyotm Execution 5 May 27th, 2008 05:31
removing saved queries cmcintos Installation and Upgrades 4 April 29th, 2008 23:20
saved query nikesh mohanlal Database Administration 0 February 28th, 2008 13:38



All times are GMT. The time now is 04:36.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

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 38 39 40