don't give up yet kris. q={!prefix f=metatag.date}2016-10&debugQuery
g'luck will On 11/17/2016 5:56 PM, Kris Musshorn wrote: This q={!prefix f=metatag.date}2016-10 returns zero records -----Original Message----- From: KRIS MUSSHORN [mailto:mussho...@comcast.net] Sent: Thursday, November 17, 2016 3:00 PM To: solr-user@lucene.apache.org<mailto:solr-user@lucene.apache.org> Subject: Re: field set up help so if the field was named metatag.date q={!prefix f=metatag.date}2016-10.... ----- Original Message ----- From: "Erik Hatcher" <erik.hatc...@gmail.com><mailto:erik.hatc...@gmail.com> To: solr-user@lucene.apache.org<mailto:solr-user@lucene.apache.org> Sent: Thursday, November 17, 2016 2:46:32 PM Subject: Re: field set up help Given what you’ve said, my hunch is you could make the query like this: q={!prefix f=field_name}2016-10 tada! ?! there’s nothing wrong with indexing dates as text like that, as long as your queries are performantly possible. And in the case of the query type you mentioned, the text/string’ish indexing you’ve done is suited quite well to prefix queries to grab dates by year, year-month, and year-month-day. But you could, if needed to get more sophisticated with date queries (DateRangeField is my new favorite) you can leverage ParseDateFieldUpdateProcessorFactory without having to change the incoming format. Erik On Nov 17, 2016, at 1:55 PM, KRIS MUSSHORN <mussho...@comcast.net><mailto:mussho...@comcast.net> wrote: I have a field in solr 5.4.1 that has values like: 2016-10-15 2016-09-10 2015-10-12 2010-09-02 Yes it is a date being stored as text. I am getting the data onto solr via nutch and the metatag plug in. The data is coming directly from the website I am crawling and I am not able to change the data at the source to something more palpable. The field is set in solr to be of type TextField that is indexed, tokenized, stored, multivalued and norms are omitted. Both the index and query analysis chains contain just the whitespace tokenizer factory and the lowercase filter factory. I need to be able to query for 2016-10 and only match 2016-10-15. Any ideas on how to set this up? TIA Kris