You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by 张智 <zh...@126.com> on 2013/07/14 04:14:08 UTC

How to from solr facet exclude specific “Tag”!

solr 4.3

this is my query request params:

<lst name="responseHeader"><int name="status">0</int><int name="QTime">15</int><lst name="params"><str name="facet">true</str><str name="indent">true</str><str name="q">*:*</str><str name="_">1373713374569</str><arr name="facet.field"><str>{!ex=city}CityId</str><str>{!ex=company}CompanyId</str></arr><str name="wt">xml</str><str name="fq">{!tag=city}CityId:729 AND {!tag=company}CompanyId:16122</str></lst></lst>

This is the query response "Facet" content:

<lst name="facet_counts"><lst name="facet_queries"/><lst name="facet_fields"><lst name="CityId"><int name="11">100171</int><int name="1404">89406</int><int name="0">77477</int><int name="1366">65780</int><int name="1362">58092</int><int name="729">29213</int><int name="798">28975</int>...<int name="7262">808</int><int name="432">776</int><int name="1146">772</int><int name="1653">765</int><int name="1078">668</int><int name="814">667</int><int name="2049">402</int><int name="456">401</int><int name="401">390</int></lst><lst name="CompanyId"><int name="16122">971</int><int name="69">0</int><int name="71">0</int><int name="72">0</int><int name="79">0</int><int name="80">0</int><int name="85">0</int><int name="88">0</int><int name="94">0</int>...<int name="98">0</int><int name="104">0</int><int name="112">0</int><int name="113">0</int><int name="118">0</int><int name="123">0</int><int name="126">0</int><int name="131">0</int><int name="136">0</int><int name="139">0</int></lst></lst><lst
  name="facet_dates"/><lst name="facet_ranges"/></lst>

You can see CityId the "Facet" is correct, it excludes the {! Tag = city} CityId: 729 queries , but CompanyId the "Facet" is not correct , he did not rule out {! Tag = company} CompanyId: 16122 queries. How to solve it ?

Re: How to from solr facet exclude specific “Tag”!

Posted by Upayavira <uv...@odoko.co.uk>.
Make your two fq clauses separate fq params? Would be better for your
caches, and would mean the tag is easily associated with the whole fq
querystring.

Upayavira

On Sun, Jul 14, 2013, at 03:14 AM, 张智 wrote:
> solr 4.3
> 
> this is my query request params:
> 
> <lst name="responseHeader"><int name="status">0</int><int
> name="QTime">15</int><lst name="params"><str name="facet">true</str><str
> name="indent">true</str><str name="q">*:*</str><str
> name="_">1373713374569</str><arr
> name="facet.field"><str>{!ex=city}CityId</str><str>{!ex=company}CompanyId</str></arr><str
> name="wt">xml</str><str name="fq">{!tag=city}CityId:729 AND
> {!tag=company}CompanyId:16122</str></lst></lst>
> 
> This is the query response "Facet" content:
> 
> <lst name="facet_counts"><lst name="facet_queries"/><lst
> name="facet_fields"><lst name="CityId"><int name="11">100171</int><int
> name="1404">89406</int><int name="0">77477</int><int
> name="1366">65780</int><int name="1362">58092</int><int
> name="729">29213</int><int name="798">28975</int>...<int
> name="7262">808</int><int name="432">776</int><int
> name="1146">772</int><int name="1653">765</int><int
> name="1078">668</int><int name="814">667</int><int
> name="2049">402</int><int name="456">401</int><int
> name="401">390</int></lst><lst name="CompanyId"><int
> name="16122">971</int><int name="69">0</int><int name="71">0</int><int
> name="72">0</int><int name="79">0</int><int name="80">0</int><int
> name="85">0</int><int name="88">0</int><int name="94">0</int>...<int
> name="98">0</int><int name="104">0</int><int name="112">0</int><int
> name="113">0</int><int name="118">0</int><int name="123">0</int><int
> name="126">0</int><int name="131">0</int><int name="136">0</int><int
> name="139">0</int></lst></lst><lst
>   name="facet_dates"/><lst name="facet_ranges"/></lst>
> 
> You can see CityId the "Facet" is correct, it excludes the {! Tag = city}
> CityId: 729 queries , but CompanyId the "Facet" is not correct , he did
> not rule out {! Tag = company} CompanyId: 16122 queries. How to solve it
> ?