How do I query mongodb with an array of strings that should be objects

[mrtwebdesign]

I'm trying to get a list of members. In mongodb the array is a list of ObjectIds. But when I run the query it finds nothing. I know the actual ID's are valid. There could be a few deleted users, but most of them exist.
On our server we are building the query with Mongoose and it works fine, but I'm not sure how to do that here. It looks like my options are to convert the strings to objects in the users query, or the original data as a post-query transformer on the data source. I've made a few attempts, but I'm not sure if I'm even on the right track.

This query works, but that's for a single user and I can specify it should be treated as an $oid.

[Pawan]

Hi, mrtwebdesign

Happy to help. What you would like is to have is an array of objects where each object has they key "$oid" and the value is each string from the array. Currently there's an array of strings. Here's an example of what that would that would look like:

{ "_id" : { "$in" : [ { "$oid" : "5f64b47aac01030026e46fa5"} , { "$oid" : "5f67afea4cebe4001ac964cc"}, { "$oid" : "5f64c3134cebe4001ac964bd"}]}}

Let me know if that helps or if you need anything else in the meantime