It can be done using streaming expressions; first a search expression, then cartesianProduct, then rollup.
It can also be done if you reindex your multivalued field into a docValues enabled field like a string. Docvalues remove duplicate values in multivalued fields. -ufuk — > On May 31, 2024, at 1:07, Natarajan, Rajeswari > <rajeswari.natara...@sap.com.invalid> wrote: > > Thanks for your reply. Is there any other way to achieve this other than by > facet query. > > Thanks, > Rajeswari > > On 5/29/24, 11:43 PM, "Mikhail Khludnev" <m...@apache.org> wrote: > > For some of these cases JSON Facets were an answer. However, topdocs > https://issues.apache.org/jira/browse/SOLR-7830 isn't available. > > On Thu, May 30, 2024 at 5:41 AM Natarajan, Rajeswari > <rajeswari.natara...@sap.com.invalid> wrote: > >> Hi , >> >> Looking to get distinct results from the query to multi value field. Field >> collapsing will not work on multi value field and not inclined to use >> faceting. Is there any other way this can be achieved. >> >> >> Thanks, >> Rajeswari >> > > > -- > Sincerely yours > Mikhail Khludnev >
