Then I don't understand your problem. Solr already does exactly what you want.
Maybe the problem is different: I assume that there never was a value of "1" in the index, leading to your confusion. Solr returns all fields as facet result where there was some value at some time as long as the the documents are somewhere in the index, even when they're marked as indexed. So there must have been a document with m_mediaType_s=1. Even if all these documents are deleted already, its values still appear in the facet result. This holds true until segments get merged so that all deleted documents are pruned. So if you send a forceMerge request, chances are good that "1" won't come up any more. -Michael Am 13.01.2017 um 15:36 schrieb Sebastian Riemer: > Hi Bill, > > Thanks, that's actually where I come from. But I don't want to exclude values > leading to a count of zero. > > Background to this: A user searched for mediaType "book" which gave him 10 > results. Now some other task/routine whatever changes all those 10 books to > be say 10 ebooks, because the type has been incorrect. The user makes a > refresh, still looking for "book" gets 0 results (which is expected) and > because we rule out facet.fields having count 0, I don't get back the > selected mediaType "book" and thus I cannot select this value in the > select-dropdown-filter for the mediaType. This leads to confusion for the > user, since he has no results, but doesn't see that it's because of he still > has that mediaType-filter set to a value "books" which now actually leads to > 0 results. > > -----Ursprüngliche Nachricht----- > Von: billnb...@gmail.com [mailto:billnb...@gmail.com] > Gesendet: Freitag, 13. Januar 2017 15:23 > An: solr-user@lucene.apache.org > Betreff: Re: AW: FacetField-Result on String-Field contains value with count > 0? > > Set mincount to 1 > > Bill Bell > Sent from mobile > > >> On Jan 13, 2017, at 7:19 AM, Sebastian Riemer <s.rie...@littera.eu> wrote: >> >> Pardon me, >> the second search should have been this: >> http://localhost:8983/solr/wemi/select?fq=m_mediaType_s:%221%22&indent >> =on&q=*:*&rows=0&start=0&wt=json (or in other words, give me all >> documents having value "1" for field "m_mediaType_s") >> >> Since this search gives zero results, why is it included in the facet.fields >> result-count list? >> >> ---- >> >> Hi, >> >> Please help me understand: >> http://localhost:8983/solr/wemi/select?facet.field=m_mediaType_s&facet=on&indent=on&q=*:*&wt=json >> returns: >> >> "facet_counts":{ >> "facet_queries":{}, >> "facet_fields":{ >> "m_mediaType_s":[ >> "2",25561, >> "3",19027, >> "10",1966, >> "11",1705, >> "12",1067, >> "4",1056, >> "5",291, >> "8",68, >> "13",2, >> "6",2, >> "7",1, >> "9",1, >> "1",0]}, >> "facet_ranges":{}, >> "facet_intervals":{}, >> "facet_heatmaps":{}}} >> >> http://localhost:8983/solr/wemi/select?fq=m_mediaType_s:%222%22&indent >> =on&q=*:*&rows=0&start=0&wt=json >> >> >> ? "response":{"numFound":25561,"start":0,"docs":[] >> >> http://localhost:8983/solr/wemi/select?fq=m_mediaType_s:%220%22&indent >> =on&q=*:*&rows=0&start=0&wt=json >> >> >> ? "response":{"numFound":0,"start":0,"docs":[] >> >> So why does the search for facet.field even contain the value "1", if it >> does not exist? >> >> And why does it e.g. not contain >> "SomeReallyCrazyOtherValueWhichLikeValue"1"DoesNotExistButLetsIncludeI >> tInTheFacetFieldsResultListAnywaysWithCountZero" : 0 >> >> Best regards, >> Sebastian >> >> Additional info, field m_mediaType_s is a string; >> <dynamicField name="*_s" type="string" indexed="true" >> stored="true" /> >> <fieldType name="string" class="solr.StrField" sortMissingLast="true" >> /> >>
