Algolia filter equivalent to SQL IN for arrays?

Question

I've got records in Algolia containing an array attribute with integer values, like :

{
  ...
  choice_ids: [1, 99, 100, 200]
  ...
}

I want to filter all records containing any value of another array. For example I search for [1, 300, 400, 600, 700], I should get the record on top because it contains 1.

Should I construct the filter with OR arguments or is there a better way?

score 12 · Accepted Answer · answered Aug 28 '16 at 09:32

12

Should I construct the filter with OR arguments or is there a better way?

Yes that's the way to go.

index.search('....', { filters: '(choice_ids=1 OR choice_ids=99 OR choice_ids=100 OR choice_ids=200)' });

answered Aug 28 '16 at 09:32

redox

2,269
13
22

Still this the best way ? No other solutions ? – maj Feb 23 '18 at 09:18
Yes, still the best way. – redox Mar 12 '18 at 12:25
1

Is there a limit on total number of values we pass in filters? – Krishna Shetty Dec 03 '21 at 08:41

score 1 · Answer 2 · answered Nov 06 '18 at 10:10

1

For me it wasn't working with '=' but with ':', meaning:

{ filters: 'choice_ids:1 OR choice_ids:99 OR choice_ids:100 OR choice_ids:200' })

answered Nov 06 '18 at 10:10

Léo Chaz Maltrait

619
7
11

score 0 · Answer 3 · answered May 16 '22 at 21:56

0

For me, neither of @Léo Chaz Maltrait or @redox answers worked. I had to format mine like:

{ filters: '(choice_ids:"1") OR (choice_ids:"99" OR (choice_ids:"100") OR (choice_ids:"200"))' })

I am also using algoliasearch npm package.

answered May 16 '22 at 21:56

Jwags

474
6
15

Algolia filter equivalent to SQL IN for arrays?

3 Answers3