Hi,
I have an index with a field called 'category'. The data is not clean, so
documents may have values such as 'ABC DEF', 'abc-def', 'ABC-def' etc. Now, I
want to facet by this field and want all such values to be clubbed together.
I created a field called 'category_facet' where I strip everything except
alphabets and then lower case the whole thing. That works fine for getting the
facets and counts, but the facet names returned ('abc def' in this case) cannot
be displayed directly. I need to get the stored value of the field (any one
will do). The only way I can think of is to fire another query with
"category_facet=abc def" and "numRows=1" to get a single result and then get
the stored value of the category field.
Is there any way of avoiding this extra query?
I am using the latest nightly build of Solr 1.3 and SolrJ.
Thanks,
Nikhil
