[ 
https://issues.apache.org/jira/browse/SOLR-14996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17376183#comment-17376183
 ] 

Michael Gibney commented on SOLR-14996:
---------------------------------------

Thanks for reporting back. I'm reluctant (and not in a position) to weigh in on 
what the "correct" behavior should be. But I feel pretty confident in my 
diagnosis of what _is_ happening, and fwiw I can readily hypothesize use cases 
where the current behavior _would_ be the desired behavior (facet counts 
consistent with collapsed result domain), even if you find it undesirable in 
your particular case.

Also, leaving aside the question of what one might consider to be the "correct" 
behavior, I strongly encourage you to take another look at {{join}} query, 
because I'm pretty sure that's the way to achieve the behavior you're looking 
for. (If I'm interpreting correctly "we cannot mention [user_id] during query 
time", please note: my example query -- {{\{!join from=user_id to=user_id 
v='job_type:thinker'\}}} -- is completely literal. i.e., "user_id" in that 
query is the literal name of the field, not a standin for a particular user_id 
value. And user_id, provided it is indexed and has docValues enabled, should 
indeed be able to be referenced in such a query).

 

> Facet incorrect counts when FQ exclusion applied with collapsing
> ----------------------------------------------------------------
>
>                 Key: SOLR-14996
>                 URL: https://issues.apache.org/jira/browse/SOLR-14996
>             Project: Solr
>          Issue Type: Bug
>          Components: faceting
>    Affects Versions: 8.6.3
>            Reporter: Yevhen Tienkaiev
>            Priority: Critical
>
> *numFound* not correct according to what is displayed in facets with 
> exclusion when used collapsing and FQ with tag.
> Here example query:
> {code}
> curl --location --request GET 
> 'http://localhost:8981/solr/test/select?facet.field={!ex=selected}job_type&facet=on&fq={!collapse%20field=user_id}&fq={!tag=selected}job_type:thinker&q=*:*&rows=0'
> {code}
> result is:
> {code}
> {
>     "responseHeader": {
>         "zkConnected": true,
>         "status": 0,
>         "QTime": 15,
>         "params": {
>             "q": "*:*",
>             "facet.field": "{!ex=selected}job_type",
>             "fq": [
>                 "{!collapse field=user_id}",
>                 "{!tag=selected}job_type:thinker"
>             ],
>             "rows": "0",
>             "facet": "on"
>         }
>     },
>     "response": {
>         "numFound": 850,
>         "start": 0,
>         "maxScore": 1.0,
>         "numFoundExact": true,
>         "docs": []
>     },
>     "facet_counts": {
>         "facet_queries": {},
>         "facet_fields": {
>             "job_type": [
>                 "runner",
>                 220,
>                 "developer",
>                 202,
>                 "digger",
>                 202,
>                 "thinker",
>                 195,
>                 "ninja",
>                 181
>             ]
>         },
>         "facet_ranges": {},
>         "facet_intervals": {},
>         "facet_heatmaps": {}
>     }
> }
> {code}
> as you can see there FQ with 
> {code}
> {!tag=selected}job_type:thinker
> {code}
> and facets with
> {code}
> {!ex=selected}job_type
> {code}
> in results I see for *thinker* 195, but *numFound* is 850.
> Expected:
> *thinker* 195, *numFound* is 195
> *or*
> *thinker* 850, *numFound* is 850
> You can use this simple project to reproduce the issue 
> https://github.com/Hronom/solr-cloud-basic-auth/tree/main/solr-cloud-playground-collapsing



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org

Reply via email to