I am not querying for a specific usernames.
Each day, there will be many usernames observed at different times.
But there might be some usernames that were never seen in the last 30 days,
but they were observed today.
That is the main challenge I am having.
How to identify which usernames from today were not seen in the last 30
days.
On Tue, Jan 20, 2015, 1:02 AM Alvaro Cabrerizo <topor...@gmail.com> wrote:
> Ok,
>
> Thus as commented before, in case your starttimeISO is single-value you
> only need to add the range clause: startTimeISO:["2015-01-19T00:
> 00:00.000Z" TO "2015-01-20T00:00:00.000Z"]". There is no need to add both
> NOT A AND B as the documents that satisfy B will automatically satisfy A.
>
> If you query:
>
> q: username:bla
>
> How many documents do you have? where they observed at different
> starttimeISO (I mean maybe you have different documents with similar names
> that where observed in different times?
>
> Regards.
>
>
>
>
>
> On Tue, Jan 20, 2015 at 9:45 AM, harish singh <harish.sing...@gmail.com>
> wrote:
>
> > Every entry in the document has a username, starttimeISO and uuid (which
> is
> > not starttimeiso)
> >
> > So every record has a starttimeISO which is the time when the username
> was
> > seen.
> >
> > The document looks like this:
> > {
> > Uuid: xxx
> > StartTimeISO: 2015-01-18T00:00:00.000Z
> > Username: abc
> > }
> >
> > There are multiple records in the document.
> > Indexing is applied on "username" and "starttimeiso" fields.
> >
>
