Multiple IDs for the same Query in MongoDB

15 views (last 30 days)
I am querying a remote MongoDB database with Matlab.
I have an array of IDs that I would like to look for and a query tipically looks like this:
query520 = sprintf('{"_ref":{$oid:"%s"}, "eventTypeId":520}', IDs{end});
Is their a way to check multiple (selected) IDs at once like this:
query520 = sprintf('{"_ref":{$oid:"%s"}, "eventTypeId":520}', IDs{1:2});
Thanks for our help and time!

Answers (1)

Guillaume
Guillaume on 29 May 2019
Seems more like a question on how to write MongoDB queries rather than about matlab. Going by the documentation there and there, probably:
query520 = sprintf('{"_ref":{$in:[%s]}, "eventTypeId":520}', strjoin(compose('{$oid:"%s"}', string(IDs(1:2))), ','));

Products


Release

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!