Search opinion needed

We have a verity search that searches db and docs.  They want to combine the results and then sort by relevance then date.  I have done the combination before by just putting it in a structure.  Any better ideas?

Use a Query of a Query to join the two search results and sort as needed. m!ke We have a verity search that searches db and docs.  They want to combine the results and then sort by relevance then date.  I have done the combination before by just putting it in a structure.  Any better ideas?

Michale's QofQ is a good idea - but don't forget you can search multiple collections at once. On Tue, Mar 25, 2008 at 8:31 AM, Stone, Lori <Lori.Stone@acqsolinc.com> wrote: > We have a verity search that searches db and docs.  They want to combine >  the results and then sort by relevance then date.  I have done the >  combination before by just putting it in a structure.  Any better ideas?

Yeah, that is exactly what I was planning on doing.  I just know how QoQ is usually the last resort so I wanted to make sure that there wasn't a better way to do it. Thanks for the input Mike and Ray! -Lori Michale's QofQ is a good idea - but don't forget you can search multiple collections at once. On Tue, Mar 25, 2008 at 8:31 AM, Stone, Lori <Lori.Stone@acqsolinc.com> wrote: > We have a verity search that searches db and docs.  They want to combine >  the results and then sort by relevance then date.  I have done the >  combination before by just putting it in a structure.  Any better ideas? > >  

On Tue, Mar 25, 2008 at 9:31 AM, Stone, Lori <Lori.Stone@acqsolinc.com> wrote: > We have a verity search that searches db and docs.  They want to combine >  the results and then sort by relevance then date.  I have done the >  combination before by just putting it in a structure.  Any better ideas? > You may want to look further at searching multiple collections, as Ray pointed out.  If you are doing two separate cfsearches and then combining the results, I don't think that the relevancy scores would match up.