How can I query/filter an elasticsearch index by an array of values?

Question

I have an elasticsearch index with numeric category ids like this:

{
  "id": "50958",
  "name": "product name",
  "description": "product description",
  "upc": "00302590602108",
  "**categories**": [
    "26",
    "39"
  ],
  "price": "15.95"
}

I want to be able to pass an array of category ids (a parent id with all of it's children, for example) and return only results that match one of those categories. I have been trying to get it to work with a term query, but no luck yet.

Also, as a new user of elasticsearch, I am wondering if I should use a filter/facet for this...

ANSWERED! I ended up using a terms query (as opposed to term). I'm still interested in knowing if there would be a benefit to using a filter or facet.

Can you please help me with this question? Thanks

AabinGunz
– AabinGunz

2014-07-15 07:00:43 +00:00
Commented Jul 15, 2014 at 7:00 — AabinGunz
– AabinGunz, Commented Jul 15, 2014 at 7:00

Andy · Accepted Answer · 2012-09-01 16:33:09Z

0

As you already discovered, a termQuery would work. I would suggest a termFilter though, since filters are faster, and cache-able.

Facets won't limit result, but they are excellent tools. They count hits within your total results of specific terms, and be used for faceted navigation.

answered Sep 1, 2012 at 16:33

Andy

8,9498 gold badges48 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

AabinGunz Over a year ago

Can you please help me with this question? Thanks

Andy Over a year ago

@AbhishekSimon yep just responded. I can include more detail in a few hours, but I linked to the type you need to use.

Collectives™ on Stack Overflow

How can I query/filter an elasticsearch index by an array of values?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related