Hi Chris,
Thanks for explaining the point system, please find below the complete
problem. Hopefully I am not doing something stupid.
I am trying to facet based on date field and apply user timezone offset so
that the faceted results are in user timezone. My faceted result is given
below,
<?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">6</int>
<lst name="params">
<str name="facet">true</str>
<str name="q">icici</str>
<str
name="facet.range.start">2011-05-02T00:00:00Z+330MINUTES</str>
<str name="facet.range">createdOnGMTDate</str>
<str
name="facet.range.end">2011-05-18T00:00:00Z</str>
<str name="facet.range.gap">+1DAY</str>
</lst>
</lst>
<lst name="facet_counts">
<lst name="facet_ranges">
<lst name="createdOnGMTDate">
<lst name="counts">
<int
name="2011-05-02T05:30:00Z">4</int>
<int
name="2011-05-03T05:30:00Z">63</int>
<int
name="2011-05-04T05:30:00Z">0</int>
<int
name="2011-05-05T05:30:00Z">0</int>
......
</lst>
<str name="gap">+1DAY</str>
<date
name="start">2011-05-02T05:30:00Z</date>
<date name="end">2011-05-18T05:30:00Z</date>
</lst>
</lst>
</lst>
</response>
Now if you notice that the response show 4 records for the 2th of May 2011
which will fall in the IST timezone (+330MINUTES), but when I try to get the
results I see that there is only 1 result for the 5th why is this happening.
<?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">5</int>
<lst name="params">
<str name="sort">createdOnGMTDate asc</str>
<str
name="fl">createdOnGMT,createdOnGMTDate,twtText</str>
<str
name="fq">createdOnGMTDate:[2011-05-01T00:00:00Z+330MINUTES TO *]
</str>
<str name="q">icici</str>
</lst>
</lst>
<result name="response" numFound="67" start="0">
<doc>
<str name="createdOnGMT">Mon, 02 May 2011 16:27:05
+0000</str>
<date
name="createdOnGMTDate">2011-05-02T16:27:05Z</date>
<str name="twtText">#TechStrat615. Infosys (business
soln & IT
outsourcer) manages damages with new
chairman K.Kamath (ex ICICI
Bank chairman) to begin Aug 21.</str>
</doc>
<doc>
<str name="createdOnGMT">Mon, 02 May 2011 19:00:44
+0000</str>
<date
name="createdOnGMTDate">2011-05-02T19:00:44Z</date>
<str name="twtText">how to get icici mobile
banking</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 01:53:05
+0000</str>
<date
name="createdOnGMTDate">2011-05-03T01:53:05Z</date>
<str name="twtText">ICICI BANK LTD, L. M. MIRAJ
branch in SANGLI,
MAHARASHTRA. IFSC Code: ICIC0006537, MICR
Code: ...
http://bit.ly/fJCuWl #ifsc #micr #bank</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 01:53:05
+0000</str>
<date
name="createdOnGMTDate">2011-05-03T01:53:05Z</date>
<str name="twtText">ICICI BANK LTD, L. M. MIRAJ
branch in SANGLI,
MAHARASHTRA. IFSC Code: ICIC0006537, MICR
Code: ...
http://bit.ly/fJCuWl #ifsc #micr #bank</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 08:52:37
+0000</str>
<date
name="createdOnGMTDate">2011-05-03T08:52:37Z</date>
<str name="twtText">RT @nice4ufan: ICICI BANK
PERSONAL LOAN
http://ee4you.blogspot.com/2011/04/icici-bank-personal-loan.html
</str>
</doc>
If I don't apply the offset the results match with the facet count, is there
something wrong in my query?
Regards,
Rohit
P.S
-----Original Message-----
From: Chris Hostetter [mailto:hossman_luc...@fucit.org]
Sent: 14 May 2011 05:28
To: solr-user@lucene.apache.org
Subject: Re: Solr Range Facets
: I did try what you suggested, but I am not getting the expected results.
The
: code is given below,
+5 points for posting the code you tried, but -10 points for not
explaining how the results you get are differnet from the results you
expect, and -5 more points for not even giving an example of the results
you did get.
In the absense of any other info about how this doesn't match your
expecations, my hunch is it's because you left out hte crucial part of my
suggestion...
: query.set("facet.range.start", "2010-01-01T00:00:00Z") ;
You said you wanted the facet results to be based on the users local
timezone, but you aren't including the "timezone offset" info that i
mentioned you should add (Unless this example is suppose to show the
results for a user whose local timezone is UTC)
See below...
: -----Original Message-----
: From: Chris Hostetter
...
: Date faceting is entirely driven by query params, so if you index your
: events using the "true" time that they happend at (formatted as a string
: in UTC) you can then select your date ranges using whatever timezone
: offset is specified by your user at query time as a UTC offset.
: facet.range.start = 2011-01-01T00:00:00Z+${useroffset}MINUTES
: facet.range.gap = +1DAY
: etc...
-Hoss
<?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">6</int>
<lst name="params">
<str name="facet">true</str>
<str name="q">icici</str>
<str name="facet.range.start">2011-05-02T00:00:00Z+330MINUTES</str>
<str name="facet.range">createdOnGMTDate</str>
<str name="facet.range.end">2011-05-18T00:00:00Z</str>
<str name="facet.range.gap">+1DAY</str>
</lst>
</lst>
<lst name="facet_counts">
<lst name="facet_queries" />
<lst name="facet_fields" />
<lst name="facet_dates" />
<lst name="facet_ranges">
<lst name="createdOnGMTDate">
<lst name="counts">
<int name="2011-05-02T05:30:00Z">4</int>
<int name="2011-05-03T05:30:00Z">63</int>
<int name="2011-05-04T05:30:00Z">0</int>
<int name="2011-05-05T05:30:00Z">0</int>
<int name="2011-05-06T05:30:00Z">0</int>
<int name="2011-05-07T05:30:00Z">0</int>
<int name="2011-05-08T05:30:00Z">0</int>
<int name="2011-05-09T05:30:00Z">0</int>
<int name="2011-05-10T05:30:00Z">0</int>
<int name="2011-05-11T05:30:00Z">0</int>
<int name="2011-05-12T05:30:00Z">0</int>
<int name="2011-05-13T05:30:00Z">0</int>
<int name="2011-05-14T05:30:00Z">0</int>
<int name="2011-05-15T05:30:00Z">0</int>
<int name="2011-05-16T05:30:00Z">0</int>
<int name="2011-05-17T05:30:00Z">0</int>
</lst>
<str name="gap">+1DAY</str>
<date name="start">2011-05-02T05:30:00Z</date>
<date name="end">2011-05-18T05:30:00Z</date>
</lst>
</lst>
</lst>
</response>
<?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">5</int>
<lst name="params">
<str name="sort">createdOnGMTDate asc</str>
<str name="fl">createdOnGMT,createdOnGMTDate,twtText</str>
<str name="fq">createdOnGMTDate:[2011-05-01T00:00:00Z+330MINUTES TO *]
</str>
<str name="q">icici</str>
</lst>
</lst>
<result name="response" numFound="67" start="0">
<doc>
<str name="createdOnGMT">Mon, 02 May 2011 16:27:05 +0000</str>
<date name="createdOnGMTDate">2011-05-02T16:27:05Z</date>
<str name="twtText">#TechStrat615. Infosys (business soln & IT
outsourcer) manages damages with new chairman K.Kamath (ex ICICI
Bank chairman) to begin Aug 21.</str>
</doc>
<doc>
<str name="createdOnGMT">Mon, 02 May 2011 19:00:44 +0000</str>
<date name="createdOnGMTDate">2011-05-02T19:00:44Z</date>
<str name="twtText">how to get icici mobile banking</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 01:53:05 +0000</str>
<date name="createdOnGMTDate">2011-05-03T01:53:05Z</date>
<str name="twtText">ICICI BANK LTD, L. M. MIRAJ branch in SANGLI,
MAHARASHTRA. IFSC Code: ICIC0006537, MICR Code: ...
http://bit.ly/fJCuWl #ifsc #micr #bank</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 01:53:05 +0000</str>
<date name="createdOnGMTDate">2011-05-03T01:53:05Z</date>
<str name="twtText">ICICI BANK LTD, L. M. MIRAJ branch in SANGLI,
MAHARASHTRA. IFSC Code: ICIC0006537, MICR Code: ...
http://bit.ly/fJCuWl #ifsc #micr #bank</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 08:52:37 +0000</str>
<date name="createdOnGMTDate">2011-05-03T08:52:37Z</date>
<str name="twtText">RT @nice4ufan: ICICI BANK PERSONAL LOAN
http://ee4you.blogspot.com/2011/04/icici-bank-personal-loan.html
</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 08:54:54 +0000</str>
<date name="createdOnGMTDate">2011-05-03T08:54:54Z</date>
<str name="twtText">ICICI Bank: Quality performance:: Kotak Securities
http://dlvr.it/QSQgP #tip #India #stock</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 08:55:02 +0000</str>
<date name="createdOnGMTDate">2011-05-03T08:55:02Z</date>
<str name="twtText">#stocks #bse #nse ICICI Bank: Quality performance::
Kotak Securities http://dlvr.it/QSQh1</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 08:55:04 +0000</str>
<date name="createdOnGMTDate">2011-05-03T08:55:04Z</date>
<str name="twtText">ICICI Bank: Quality performance:: Kotak Securities
http://dlvr.it/QSQkH #BSE #NSE #Tips</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 08:55:04 +0000</str>
<date name="createdOnGMTDate">2011-05-03T08:55:04Z</date>
<str name="twtText">ICICI Bank: Quality performance:: Kotak Securities
http://dlvr.it/QSQkK #stock #tip #india</str>
</doc>
<doc>
<str name="createdOnGMT">Tue, 03 May 2011 09:11:16 +0000</str>
<date name="createdOnGMTDate">2011-05-03T09:11:16Z</date>
<str name="twtText">sbi forex rates vs icici Forex Foreign Exchange
http://bit.ly/klSRyL</str>
</doc>
</result>
</response>
