You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@solr.apache.org by "Zhang Haili (Jira)" <ji...@apache.org> on 2021/09/15 08:13:00 UTC

[jira] [Commented] (SOLR-15623) how to filter for subquery when subquery numFound is 0

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

Zhang Haili commented on SOLR-15623:
------------------------------------

[~ctargett], 

Could you access the url :

[http://shi6w710:8983/solr/qdb_core/select?%20%20MyLogID.fq=CheckerDisplayName%3A(Early%5C%20Chamfer%5C%20or%5C%20Edge%5C%20Blend)%20&%20MyLogID.fl=QdbLogID%20&%20MyLogID.rows=1&MyLogID.q=%7B!terms%20f%3DQdbLogID%20v%3D%24row.QdbLogID%7D%20&fl=QdbLogID%2CPartFileName%2CMyLogID%3A%5Bsubquery%5D&q=QdbDataType%3APart%20AND%20PartFileName%3AComp1*&rows=100]

I use solr db, the content are classified two types, I want to query both the two type and get the common because the two type have the same 'QdbLogID'.

So I try to use the subquery, but there are  some defects about the subquery.  the subquery numFound =0 will be retrieve too. It may cause huge data. Is there some solution to filter the numFound=0 or sort the filtering result.

!image-2021-09-15-01-11-42-978.png!

 

> how to filter for subquery when subquery numFound is 0
> ------------------------------------------------------
>
>                 Key: SOLR-15623
>                 URL: https://issues.apache.org/jira/browse/SOLR-15623
>             Project: Solr
>          Issue Type: New Feature
>      Security Level: Public(Default Security Level. Issues are Public) 
>          Components: clients - java
>    Affects Versions: 8.8.2
>            Reporter: Zhang Haili
>            Priority: Major
>              Labels: features
>         Attachments: image-2021-09-10-23-16-56-406.png, image-2021-09-15-01-11-42-978.png
>
>
> !image-2021-09-10-23-16-56-406.png!



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

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