Multiple IDs for the same Query in MongoDB

Question

Philippe Walliser 2019-5-29

回答： Guillaume 2019-5-29

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!

Answer 1

Guillaume 2019-5-29

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))), ','));