It is not just one document that would be returned, it one document per person. That is a little trickier.
----- Original Message ----- From: "Michael Sokolov" <soko...@ifactory.com> To: solr-user@lucene.apache.org Cc: "l blevins" <l.blev...@comcast.net> Sent: Wednesday, March 9, 2011 7:46:10 PM Subject: Re: Fwd: some relational-type groupig with search Probably you can just sort by date (one way and then the other) and limit your result set to a single document. That should free up enough budget for the bonuses of the highly-placed people, I think :) On 3/9/2011 4:05 PM, l.blev...@comcast.net wrote: > ----- Forwarded Message ----- > From: "l blevins"<l.blev...@comcast.net> > To: "solr user mail"<solr-user-h...@lucene.apache.org> > Sent: Wednesday, March 9, 2011 4:03:06 PM > Subject: some relational-type groupig with search > > > > > I have a large database for which we have some good search capabilties now, > but am interested to see if SOLR might be usable instead. That would gain us > the additional text-search features and eliminate the high fees for some of > the database features. > > > > If I have fields such as<person_id>,<document_date>, and<measurement_value>. > I need to be able to fullfil the following types of searches that I cannot > figure out how to do now: > > > > * limit search to only the most recent (or earliest) document per person > along with whatever other criteria is present (each person's LAST or FIRST > document), > > * search and only return the most recent document per person (LASTor > FIRST meeting the other criteria), > > * limit search to only the documents with the max or > min<measurement_value> per person, > * search and return only the max or min<measurement_value> per person > > > > All of these boil down to limiting by the max or min of either a date or > numeric field within a group (by person in this case). I know these features > are considered relational and that SOLR has declared that it is not really a > relational search engine, but a number of highly placed persons that I work > for are very interested in using SOLR. If we could satisfy this type of > query, SOLR could fit our needs so I feel compelled to ask this group if > these searches are possible.
