Thank you, Alex. > Sorry, your question a bit confusing. Y. Sorry.
> Also, is this last month as in 'January' (rolling monthly) or as in 'last 30 > days' (rolling daily). Ideally, the latter, if this is possible to calculate dynamically in response to a query. My backoff method (if the 'rolling daily' method isn't possible), would be to index monthly stats and then just use the range query as you suggested. -----Original Message----- From: Alexandre Rafalovitch [mailto:arafa...@gmail.com] Sent: Sunday, June 5, 2016 12:52 AM To: solr-user <solr-user@lucene.apache.org> Subject: Re: find stores with sales of > $x in last 2 months ? 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
