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.
