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 blevinsl.blev...@comcast.net
To: solr user mailsolr-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 asperson_id,document_date, andmeasurement_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 minmeasurement_value
per person,
* search and return only the max or minmeasurement_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.