: Faceting on multivalued field
Why not count them on the way in and just store that number along
with the original e-mail?
Best
Erick
On Sun, Apr 3, 2011 at 10:10 PM, Kaushik Chakraborty wrote:
> Ok. My expectation was since "comment_post_id" is a MultiValued field hence
>
I hadn't thought that far. But if you can change your query to
sum the fields that'd be easiest.
Mostly, I was thinking that since that information is known up
front, storing it with the document makes sense and would
avoid costly Solr work.
I don't know of any transformers that would do this for
Are you implying to change the DB query of the nested entity which fetches
the comments (query is in my post) or something can be done during the index
like using Transformers etc. ?
Thanks,
Kaushik
On Mon, Apr 4, 2011 at 8:07 AM, Erick Erickson wrote:
> Why not count them on the way in and jus
Why not count them on the way in and just store that number along
with the original e-mail?
Best
Erick
On Sun, Apr 3, 2011 at 10:10 PM, Kaushik Chakraborty wrote:
> Ok. My expectation was since "comment_post_id" is a MultiValued field hence
> it would appear multiple times (i.e. for each comment
Wouldn't you want to extract your original data format from the index and then
'count' the comments for each post ?
I don't think facets are appropriate.
On Apr 3, 2011, at 22:10, Kaushik Chakraborty wrote:
> Ok. My expectation was since "comment_post_id" is a MultiValued field hence
> it wou
Ok. My expectation was since "comment_post_id" is a MultiValued field hence
it would appear multiple times (i.e. for each comment). And hence when I
would facet with that field it would also give me the count of those many
documents where comment_post_id appears.
My requirement is getting total fo
Hmmm, I think you're misunderstanding faceting. It's counting the
number of documents that have a particular value. So if you're
faceting on "comment_post_id", there is one and only one document
with that value (assuming that the comment_post_ids are unique).
Which is what's being reported This