Nice, thank you very much for your explanation!
>> 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.
I did not know about that! That makes perfect sense. I am quite sure there has
been a time where that field contained the value "1". Even more, as now where I
rebuild my index, the value "1" is not present as facet.field result anymore.
I'll think about how to deal with my situation then, maybe it would be better
to keep solr filtering out 0-count facet-fields and insert the filterquery
leading to 0 results into the select-dropdown "manually".
-----Ursprüngliche Nachricht-----
Von: Michael Kuhlmann [mailto:k...@solr.info]
Gesendet: Freitag, 13. Januar 2017 15:43
An: solr-user@lucene.apache.org
Betreff: Re: FacetField-Result on String-Field contains value with count 0?
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&inden
>> t =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&inden
>> t
>> =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&inden
>> t
>> =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"DoesNotExistButLetsInclude
>> I 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"
>> />
>>
