Vespa query filter - how to check whether a specific int is in a document's int array field

Question

What's the proper way to check whether an integer is inside an array field when filtering in a Vespa query?

Given the following field in a document:

field location_ids type array<int> {
    indexing: summary | attribute
}

I want to filter documents that contain a specific integer ID:

{'yql': 'SELECT * FROM doc WHERE userQuery() AND <int X in location_ids>',
'query': 'some query text'
}

I'm not sure how to do this with an int array, as the docs and project examples dealt mainly with string arrays.

Any help appreciated!

score 3 · Accepted Answer · answered Dec 13 '22 at 09:46

3

For a single value X

{'yql': 'SELECT * FROM doc WHERE userQuery() AND location_ids=X',
'query': 'some query text'
}

Will match if X is in the array.

answered Dec 13 '22 at 09:46

score 0 · Answer 2 · answered Dec 13 '22 at 10:19

0

answered Dec 13 '22 at 10:19

Jon

Great thanks Jon, I'll take a look again. I didn't realise it meant integers could be evaluated directly against arrays. – standalone_2045 Dec 13 '22 at 14:45

2 Answers2