----- 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.