Is it possible to run a query selecting values that exist in a provided list? e.g. something like:
SELECT u FROM User m WHERE u.username IN ('test_user','anotheruser')
I've tried various combinations of this including passing the list as a named parameter but without any joy (error below). The only similar examples I can find in the docs involve a join query - but my list isn't in the database - and the MEMBER OF operator doesn't seem to do what I want (although I may be using it incorrectly!
Any advice would be much appreciated and apologies in advance if I've done something silly or missed something simple :-)
The error I'm seeing is:
Caused by: com.objectdb.o.UserException: Unexpected query token 'IN' at com.objectdb.o.MSG.d(MSG.java:61) at com.objectdb.o.TKN.J(TKN.java:755) at com.objectdb.o.TKI.s(TKI.java:229) at com.objectdb.o.QPR.o(QPR.java:158) at com.objectdb.o.QRC.<init>(QRC.java:122) at com.objectdb.o.QRM.UR(QRM.java:242) at com.objectdb.o.MST.UR(MST.java:884) at com.objectdb.o.WRA.UR(WRA.java:286) at com.objectdb.o.WSM.UR(WSM.java:113) at com.objectdb.o.STC.r(STC.java:421) at com.objectdb.o.SHN.ah(SHN.java:468) at com.objectdb.o.SHN.J(SHN.java:146) at com.objectdb.o.HND.run(HND.java:133) at java.lang.Thread.run(Thread.java:619)