Hi, I have asked a question on Stackoverflow: http://stackoverflow.com/questions/28036051/solr-newly-observed-facets
I searched the mailing list and found that not many reply there. So asking the same question here: have two fields in my solr index data: "userName" and "startTimeISO" along with many other fields. Now I want to query for all the "userNames" that were seen TODAY but not seen in the last 30 days. Basically, I am trying to find out Newly Observed UserNames for today. Now the Solr Facet query I am running is: facet.pivot: "userName,startTimeISO", fq: " NOT startTimeISO:["2014-12-20T00:00:00.000Z" TO "2015-01-18T00:00:00.000Z"] AND startTimeISO:["2015-01-19T00:00:00.000Z" TO "2015-01-20T00:00:00.000Z"]" But I am for some reason getting incorrect results. For example, I see userName: "bla" the above query. If I run the same query for tomorrow, I am again see "bla" in my Facet Results. I am some how not able to get the correct logic. Perhaps I am not using all the tools provided by solr, which I am unaware of? Can someone help me here? I dont mind testing all of your suggestions and coming back and forth with different suggestions. Thanks, Harish
