Are you asking for just numerical comparison during search or about a way to aggregate numbers from multiple records? Also, is this last month as in 'January' (rolling monthly) or as in 'last 30 days' (rolling daily). Sorry, your question a bit confusing.
Numerical comparison is just a range (numField:[x TO *]) as per https://cwiki.apache.org/confluence/display/solr/The+Standard+Query+Parser#TheStandardQueryParser-RangeSearches https://cwiki.apache.org/confluence/display/solr/The+Standard+Query+Parser#TheStandardQueryParser-DifferencesbetweenLuceneQueryParserandtheSolrStandardQueryParser Regards, Alex. ---- Newsletter and resources for Solr beginners and intermediates: http://www.solr-start.com/ On 3 June 2016 at 23:23, Allison, Timothy B. <talli...@mitre.org> wrote: > All, > This is a toy example, but is there a way to search for, say, stores with > sales of > $x in the last 2 months with Solr? > $x and the time frame are selected by the user at query time. > > If the queries could be constrained (this is still tbd), I could see updating > "stats" fields within each store document on a daily basis > (sales_last_1_month, sales_last_2_months, sales_last_3_months...etc). The > dataset is fairly small and daily updates of this nature would not be > prohibitive. > > Or, is this trying to use a screw driver where a hammer is required? > > Thank you. > > Best, > > Tim
