is startTimeISO single or multi-valued? (In other words, do you add a new value to startTimeISO everytime a document is observed or just the first time?)
The idea is to clarify the data you store in the index. So how does your document look like: id:XXX-YYY-ZZZ name: theName startTimeISO:[2015-01-17T00:00:00.000Z, 2015-01-17T00:00:00.000Z, 2015-01-19T00:00:00.000Z] or id:XXX-YYY-ZZZ name: theName startTimeISO:"2015-01-17T00:00:00.000Z" Again, when you ask for documents with name bla, what do you get, just one or various? Regards On Tue, Jan 20, 2015 at 8:55 AM, harish singh <harish.sing...@gmail.com> wrote: > yes. Fieldtype for startTimeISO is date. > My issue is I need to find out all the "newly observed" usernames for a > given day. > So, for today, If I am saying that username "xyz" is newly observed, then > it means that this username "xyz" was not present in the last 30 days data > and it was only observed today. So it is "new" > > Hope I could explain it to you well. Ask me for any more questions > > On Mon, Jan 19, 2015 at 11:45 PM, Alvaro Cabrerizo <topor...@gmail.com> > wrote: > > > At first impression, everything seems ok. > > > > Anyway, is the startTimeISO single-value or multivalued field? In case it > > is single-value the clause startTimeISO:["2015-01-19T00: > > 00:00.000Z" TO "2015-01-20T00:00:00.000Z"]" is sufficient to exclude > other > > period of time. I also guess that the startTimeISO fieldtype is date. > > > > Other option for rewriting your query (just for testing as I can't find > any > > problem in the query you presented) > > > > q=*:* > > fq=startTimeISO:[NOW/DAY-1DAYS TO NOW] > > raw parameters: facet.pivot=userName,startTimeISO > > > > It will be also helpful to know the raw response, just to discard that > the > > name bla doesnt appear in different documents. For example usin: > > > > query: userName:bla > > fq=startTimeISO:[NOW/DAY-1DAYS TO NOW] > > fl= id,userName, startTimeISO > > > > > > Hope it helps. > > > > > > > > > > > > On Tue, Jan 20, 2015 at 5:09 AM, harish singh <harish.sing...@gmail.com> > > wrote: > > > > > 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 > > > > > >
