The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Query for Saved Searches

SOLVED
Go to solution
Highlighted
Raj Ghimire
Occasional Visitor

Query for Saved Searches

Hi,
Can anyone help me with a way to find out "Search details" of a Saved Searche of a user ?

Some of our Users have many their own Saved Searches and have performance issues with few of them regularly. I want to look at their Search Details and try to fine tune it without having to login as themselves.
Can anyone help me on this regard ?
Thank in advance.
-Raj
2 REPLIES
Erik Cole_1
Esteemed Contributor
Solution

Re: Query for Saved Searches

The SQL isn't saved as such, but you can find the saved searches & their filter values in

KNTA_SAVED_SEARCHES
KNTA_SAVED_SEARCH_FILTERS
Raj Ghimire
Occasional Visitor

Re: Query for Saved Searches

Thank you Eric !
Not sure how I missed those :-)
Looks like all I really needed was the SAVED_SEARCH_ID value and I was able to pull the saved searches of other users right on my own window.
Thanks.
-Raj
//Add this to "OnDomLoad" event