Have you looked at
https://solr.apache.org/guide/8_11/faceting.html#limiting-facet-with-certain-terms
Is something like *facet.field={!terms='user1,user2'}field1* what you want?
- Andy -
On Tue, Feb 28, 2023 at 3:36 AM Deepak Michael
<dmich...@proofpoint.com.invalid> wrote:
> Hi
>
> I have a muti-valued field, containing usernames, that I want to facet on,
> but I only want facets on a sub-set of those usernames.
> For example, if I have these docs
>
> doc1: { field1: [user1, user2, user4] }
> doc2: { field1: [user1, user3, user5], }
> doc3: { field1: [user3, user4, user6], }
>
> I'd like to be facet on field1 so that I get the following results:
>
> user1: 2
> user2: 1
>
> I tried having a query limiting the usernames and a facet on the usernames
> field, like so:
>
> {
> "query": "field1:( user1 OR user2)",
> "facet": { "specialUsers" : {"type": "terms", "field" : "field1"}}
> }
>
> but that returns facets for each of the values in (including user3, user4
> and user5).
>
> The unique values for usernames, across all documents in our index, could
> be in millions.
> I tried the `query` facet but that would mean having to add a `query`
> facet for each username to have a bucket on.
> I also see that the `prefix` option does something similar to what we want
> - which is slotting a bucket for each username that matched the
> criteria(prefix).
> In our case what's required is like a whitelist of field values for which
> the facets are to be included. We're looking at a custom faceting solution
> for this.
> With what’s available, is it possible to extend the JSON facets so that I
> can register a new custom facet processor? Or is there another way to do
> this?
>
> Thanks,
> Deepak
>
