You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Alexandre Rafalovitch (JIRA)" <ji...@apache.org> on 2017/12/21 16:35:00 UTC
[jira] [Commented] (SOLR-11788) conjunction of filterQueries not
working properly
[ https://issues.apache.org/jira/browse/SOLR-11788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16300242#comment-16300242 ]
Alexandre Rafalovitch commented on SOLR-11788:
----------------------------------------------
This kinds of questions belong on the Solr User mailing list first. Jira is for bugs against the core product.
Either way, Just try having two fq parameters, they add up together. So, ?q=x&fq=y&fq=z
> conjunction of filterQueries not working properly
> -------------------------------------------------
>
> Key: SOLR-11788
> URL: https://issues.apache.org/jira/browse/SOLR-11788
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Affects Versions: 6.4.1
> Reporter: Patrick Klampfl
>
> those two filter queries work fine individually and lead to the same result:
> 1. all brands of products with application 50
> http://localhost:8983/solr/master_wac_WacBrandClassificationClass_flop/select?q=*:*&fq={!join%20from=brands_string_mv%20to=code_string%20fromIndex=master_wac_Product_flop}applications_string_mv:50
> 2. all brands of products with category 100
> http://localhost:8983/solr/master_wac_WacBrandClassificationClass_flop/select?q=*:*&fq={!join%20from=brands_string_mv%20to=code_string%20fromIndex=master_wac_Product_flop}category_string_mv:100
> although 1 and 2 have the exact same result set, the conjunction of both does not work
> 3. combination:
> http://localhost:8983/solr/master_wac_WacBrandClassificationClass_flop/select?q=*:*&fq={!join%20from=brands_string_mv%20to=code_string%20fromIndex=master_wac_Product_flop}applications_string_mv:50,{!join%20from=brands_string_mv%20to=code_string%20fromIndex=master_wac_Product_flop}category_string_mv:100
> Result for 1:
> {code:java}
> <?xml version="1.0" encoding="UTF-8"?>
> <response>
> <lst name="responseHeader"><int name="status">0</int><int name="QTime">0</int><lst name="params"><str name="q">*:*</str><str name="fq">{!join from=brands_string_mv to=code_string fromIndex=master_wac_Product_flop}applications_string_mv:50</str></lst></lst><result name="response" numFound="1" start="0"><doc><long name="indexOperationId">99207272441184304</long><str name="id">wackerMarketingClassificationCatalog/Default/36</str><long name="pk">8796094169230</long><str name="catalogId">wackerMarketingClassificationCatalog</str><str name="catalogVersion">Default</str><str name="itemtype_string">WacBrandClassificationClass</str><str name="code_string">36</str><arr name="autosuggest_fr"><str>ELASTOSIL ® WT</str></arr><str name="name_sortable_fr_sortabletext">ELASTOSIL ® WT</str><str name="name_text_fr">ELASTOSIL ® WT</str><arr name="spellcheck_fr"><str>ELASTOSIL ® WT</str></arr><str name="name_text_en">ELASTOSIL ® WT</str><str name="name_sortable_en_sortabletext">ELASTOSIL ® WT</str><arr name="autosuggest_en"><str>ELASTOSIL ® WT</str></arr><arr name="spellcheck_en"><str>ELASTOSIL ® WT</str></arr><str name="name_text_de">ELASTOSIL ® WT</str><str name="name_sortable_de_sortabletext">ELASTOSIL ® WT</str><arr name="autosuggest_de"><str>ELASTOSIL ® WT</str></arr><arr name="spellcheck_de"><str>ELASTOSIL ® WT</str></arr><str name="indexedType_string">WacBrandClassificationClass</str><long name="_version_">1587316359348355073</long></doc></result>
> </response>
> {code}
> Result for 2:
> {code:java}
> <?xml version="1.0" encoding="UTF-8"?>
> <response>
> <lst name="responseHeader"><int name="status">0</int><int name="QTime">0</int><lst name="params"><str name="q">*:*</str><str name="fq">{!join from=brands_string_mv to=code_string fromIndex=master_wac_Product_flop}category_string_mv:100</str></lst></lst><result name="response" numFound="1" start="0"><doc><long name="indexOperationId">99207272441184304</long><str name="id">wackerMarketingClassificationCatalog/Default/36</str><long name="pk">8796094169230</long><str name="catalogId">wackerMarketingClassificationCatalog</str><str name="catalogVersion">Default</str><str name="itemtype_string">WacBrandClassificationClass</str><str name="code_string">36</str><arr name="autosuggest_fr"><str>ELASTOSIL ® WT</str></arr><str name="name_sortable_fr_sortabletext">ELASTOSIL ® WT</str><str name="name_text_fr">ELASTOSIL ® WT</str><arr name="spellcheck_fr"><str>ELASTOSIL ® WT</str></arr><str name="name_text_en">ELASTOSIL ® WT</str><str name="name_sortable_en_sortabletext">ELASTOSIL ® WT</str><arr name="autosuggest_en"><str>ELASTOSIL ® WT</str></arr><arr name="spellcheck_en"><str>ELASTOSIL ® WT</str></arr><str name="name_text_de">ELASTOSIL ® WT</str><str name="name_sortable_de_sortabletext">ELASTOSIL ® WT</str><arr name="autosuggest_de"><str>ELASTOSIL ® WT</str></arr><arr name="spellcheck_de"><str>ELASTOSIL ® WT</str></arr><str name="indexedType_string">WacBrandClassificationClass</str><long name="_version_">1587316359348355073</long></doc></result>
> </response>
> {code}
> Result for 3 (combination of fq 1 and 2):
> {code:java}
> <?xml version="1.0" encoding="UTF-8"?>
> <response>
> <lst name="responseHeader"><int name="status">0</int><int name="QTime">0</int><lst name="params"><str name="q">*:*</str><str name="fq">{!join from=brands_string_mv to=code_string fromIndex=master_wac_Product_flop}applications_string_mv:50,{!join from=brands_string_mv to=code_string fromIndex=master_wac_Product_flop}category_string_mv:100</str></lst></lst><result name="response" numFound="0" start="0"></result>
> </response>
> {code}
> this filterquery however works (and leads to the same result as 1 and 2):
> http://localhost:8983/solr/master_wac_WacBrandClassificationClass_flop/select?q=*:*&fq={!join%20from=brands_string_mv%20to=code_string%20fromIndex=master_wac_Product_flop}category_string_mv:100 AND applications_string_mv:50
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org