Syntax error when query with "IN" - Realm js

604 Views Asked by At

Background

Framework: React Native

Library: Realm JS

I am writing a query to search whether an ID is included in a collection

following the official doc in https://static.realm.io/downloads/files/NSPredicateCheatsheet.pdf

Left hand expression must appear in collection specified by right hand expression. i.e. name IN {‘Milk’, ‘Eggs’, ‘Bread’}

Problem

When applying this query .filtered('subcategoryId IN {"a","b"}')

Render Error: Invalid predicate: 'subcategoryId IN {"a","b"}: syntax error, unexpected '{'

Error message

I've tried different syntax on the right side collection, still doesn't work.

Anyone has similar experience?

1

There are 1 best solutions below

0
On

According to the documentation List Comparisons you just need to enter the parameters in the second argument of the function

params = ["a","b"]
.filtered('subcategoryId IN $0', params)