Home » Other » Suggestions & Feedback » Exclude locked topics from search.
Exclude locked topics from search. [message #252248] Wed, 18 July 2007 05:51 Go to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Hello,

Just now I wanted to read up on different options for doing *drumroll* pivot queries.

The problem I encountered when searching for that was that about 95% of the search results were actually just locked 'search for "pivot"' topics.

Is there any possibility to exclude locked topics from the search result?

Re: Exclude locked topics from search. [message #252250 is a reply to message #252248] Wed, 18 July 2007 06:32 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sure. Just add
WHERE topic_locked IS NOT NULL

Just kidding, of course ... but true, there are so many "Search for it! (+ lock, eventually)" answers there, especially in the Newbies Forum. It makes searching a frustrating business sometimes.

However, there's a workaround: search for "pivot" in the Newbies Forum, use "Filter by user" (choose one among Maaher, Frank, rleishman, Michel Cadot, joy division, JRowbottom, Barbara Boehmer, William Robertson etc.) and, finally, "Sort results by date in ASCENDING order" (as the most recent posts are of the "search for it" type).
Re: Exclude locked topics from search. [message #252261 is a reply to message #252250] Wed, 18 July 2007 07:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
My first thought was maybe we should add a sticky in the SQL Experts forum for this kind of question with different solutions and/or links (as there is one "How to Identify Performance Bottleneck in 10g" in Performance Tuning)...
...but who read the stickies?

Regards
Michel
Re: Exclude locked topics from search. [message #252263 is a reply to message #252261] Wed, 18 July 2007 07:27 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I have been thinking about it too. Perhaps such threads should be transformed to Wiki subjects.

MHE
Re: Exclude locked topics from search. [message #252266 is a reply to message #252263] Wed, 18 July 2007 07:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I agree but this does not replace a sticky as most just read (or more precisely post in) forum and not wiki.

Regadrs
Michel
Re: Exclude locked topics from search. [message #252276 is a reply to message #252266] Wed, 18 July 2007 08:06 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
And advanced search on "pivot and not search" on the site-wide search engine (if one wants limited to the Message Forums) seems also to work quite well.
Previous Topic: OraFAQ Popups
Next Topic: Downtime - Out of disk space
Goto Forum:
  


Current Time: Fri Dec 09 00:21:01 CST 2016

Total time taken to generate the page: 0.20620 seconds