I think I solve it... It seems to be because of the - that's just before the
query facet name....
--
Mauro Asprea
E-Mail: mauroasp...@gmail.com
Mobile: +34 654297582
Skype: mauro.asprea
On Tuesday, January 10, 2012 at 11:33 AM, Mauro Asprea wrote:
> Hi, I;m having issues using the "new" way of faceting dates with the Query
> Facets.
>
> The issue is that it is returning wrong counts. I tested it using a Date
> Facet instead and the Dated one did result correct counters. I'm using
> Sunspot RSolr client and I'm using also new folding/group feature.
>
> This is my query tested against the Solr admin web interface:
>
> /select?wt=ruby&fq=type:Movie&fq=event_id_i:[1%20TO%20*]&sort=location_weight_i%20desc&q="Actividad%20paranormal%203"&fl=*%20score&qf=name_texts%20location_name_text&defType=dismax&start=0&rows=12&group=true&group.field=event_id_str_s&group.field=location_name_str_s&group.sort=date_start_dt%20asc&group.limit=10&group.limit=1&facet=true&f.date_start_facet_dt.facet.mincount=1&facet.date=date_start_facet_dt&f.date_start_facet_dt.facet.date.start=2012-01-10T09:44:22Z&f.date_start_facet_dt.facet.date.end=2012-01-11T08:59:59Z&f.date_start_facet_dt.facet.date.gap=%2B86400SECONDS&facet.query=-date_start_facet_dt:[2012\-01\-10T09\:44\:22Z%20TO%202012\-01\-11T08\:59\:59Z]
>
> The important parts here are:
>
> The Query Facet
> facet.query=-date_start_facet_dt:[2012\-01\-10T09\:44\:22Z TO
> 2012\-01\-11T08\:59\:59Z]
>
>
> The Date Facet
> f.date_start_facet_dt.facet.mincount=1
> facet.date=date_start_facet_dt
> f.date_start_facet_dt.facet.date.start=2012-01-10T09:44:22Z
> f.date_start_facet_dt.facet.date.end=2012-01-11T08:59:59Z
> f.date_start_facet_dt.facet.date.gap=%2B86400SECONDS
>
> As you can see both facets have the same "range"
>
> Now the important part of the results:
> 'facet_counts'=>{
> 'facet_queries'=>{
> '-date_start_facet_dt:[2012\\-01\\-10T09\\:44\\:22Z TO
> 2012\\-01\\-11T08\\:59\\:59Z]' => 26},
> 'facet_fields'=>{},
> 'facet_dates'=> {
> 'date_start_facet_dt'=>{
> '2012-01-10T09:44:22Z'=>4,
> 'gap'=>'+86400SECONDS',
> 'start'=>'2012-01-10T09:44:22Z',
> 'end'=>'2012-01-11T09:44:22Z'}}
> ,'facet_ranges'=>{}}}
>
>
> As you can see for the same ranges I'm getting different counts. The CORRECT
> one is the facet_dates ones.
>
> BTW I'm using Solr Implementation Version: 3.5.0 1204988 - simon - 2011-11-22
> 14:54:38
>
> Is this a KNOW BUG? Please Help! :D
>
> --
> Mauro Asprea
>
> E-Mail: mauroasp...@gmail.com (mailto:mauroasp...@gmail.com)
> Mobile: +34 654297582
> Skype: mauro.asprea
>
>
>
>
