Re: searching only within a date range

2019-06-07 Thread Mark Fenbers - NOAA Federal
Disregard my previous response. When I reindexed, something went wrong and so my Lucene database was empty, which explains the immediate results and 0 results. I reindexed again (properly) and all is working find now. Thanks for the help. Mark On Fri, Jun 7, 2019 at 10:40 AM Erick Erickson wro

Re: searching only within a date range

2019-06-07 Thread Mark Fenbers - NOAA Federal
I added "posttime" to the schema first thing this morning, but your message reminded me that I needed to re-index the table, which I did. My schema entry: But my SQL contains "SELECT posttime as id" as so I tried both "posttime" and "id" in my setParam() function, namely, query.setParam("fq", "

Re: searching only within a date range

2019-06-07 Thread Erick Erickson
Yeah, it can be opaque… My first guess is that you may not have a field “posttime” defined in your schema and/or documents. For searching it needs “indexed=true” and for faceting/grouping/sorting it should have “docValues=true”. That’s what your original facet query was telling you, the field i

Re: searching only within a date range

2019-06-07 Thread Mark Fenbers - NOAA Federal
So, instead of addDateRangeFacet(), I used: query.setParam("fq", "posttime:[2010-01-01T00:00:00Z TO 2015-01-01T00:00:00Z]"); I didn't get any errors, but the query returned immediately with 0 results. Without this contraint, it searches 13,000 records and takes 1 to 2 minutes and returns 356 reco

Re: searching only within a date range

2019-06-07 Thread Andrea Gazzarini
Hi Mark, you are using a "range facet" which is a "query-shape" feature, it doesn't have any constraint on the results (i.e. it doesn't filter at all). You need to add a filter query [1] with a date range clause (e.g. fq=field:[ TO or *>]). Best, Andrea [1] https://lucene.apache.org/solr/gui

searching only within a date range

2019-06-07 Thread Mark Fenbers - NOAA Federal
Hello! I have a search setup and it works fine. I search a text field called "logtext" in a database table. My Java code is like this: SolrQuery query - new SolrQuery(); query.setQuery(searchWord); query.setParam("df", "logtext"); Then I execute the search... and it works just great. But now