lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kenneth hansen <kenh...@hotmail.co.uk>
Subject RE: Newbie: document count and facets
Date Tue, 11 Oct 2011 12:25:05 GMT

ok, 
I'll try to answer this myself. Would this be correct to give me the data I need?
 
http://localhost:8080/solr-3.3.0/select/?
q=accountId:12345
&start=0
&rows=10
&indent=on
&facet=true
&facet.date=createdDate
&f.createdDate.facet.date.start=NOW/DAYS-1MONTHS
&f.createdDate.facet.date.end=NOW
&f.createdDate.facet.date.gap=%2b1MONTH
&facet.field=isClosed
&facet.mincount=1

 

> From: kenhans@hotmail.co.uk
> To: solr-user@lucene.apache.org
> Subject: Newbie: document count and facets
> Date: Mon, 10 Oct 2011 14:47:07 +0100
> 
> 
> hello,
> I'm quite new to Solr and are trying to get a grip on it all. I'm currently reading and
enjoying the "Solr 1.4 Enterprise Search Server" book. I'm trying and failing and need some
advise on the following.
> 
> given the following schema for "subscriptions"
> 
> <schema name="example" version="1.1">
> <types>
> <fieldType name="string" class="solr.StrField" sortMissingLast="true" omitNorms="true"/>
> <fieldType name="date" class="solr.TrieDateField" omitNorms="true" precisionStep="0"
positionIncrementGap="0"/>
> <fieldType name="boolean" class="solr.BoolField" sortMissingLast="true" omitNorms="true"/>
> </types>
> <fields>
> <field name="subscriptionId" type="string" indexed="true" stored="true" multiValued="false"
required="true"/>
> <field name="accountId" type="string" indexed="true" stored="true" multiValued="false"/>
> <field name="isClosed" type="boolean" indexed="true" stored="true" multiValued="false"/>
> <field name="createdDate" type="date" indexed="true" stored="true" multiValued="false"/>
> </fields>
> <uniqueKey>subscriptionId</uniqueKey>
> </schema>
> 
> I would like to group per accountId, and facet the isClosed per accountId. In addition,
I would like to see the number of created subscriptions since a given date. Would that be
possible? I just can't figure out how to do the grouping...
> 
> Something like this:
> 
> Number of subscriptions for accountId 12345: 100
> Created subscriptions since 01/01/2011: 70 
> Closed subscriptions: 10
> 
> any advise would be highly appreciated
> 
> regards,
> Kenneth 
 		 	   		  
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message