Querying Binary Field In MongoDB Compass

Question

I am trying to query a binary field in mongo db. The data looks like this:

{"_id":"WE8fSixi8EuWnUiThhZdlw=="}

I've tried a lot of things for example:

{ '_id': new Binary( 'WE8fSixi8EuWnUiThhZdlw==', Binary.SUBTYPE_DEFAULT) }
{ '_id': Binary( 'WE8fSixi8EuWnUiThhZdlw==', 0) }

etc

Nothing seems to be working, have exhausted google and the mongo documentation, any helper would be amazing.

Wan B. · Accepted Answer · 2020-03-07 05:02:07Z

15

UPDATE:

Now you should be able to query UUID and BinData from MongoDB Compass v1.20+ (COMPASS-1083). For example: {"field": BinData(0, "valid_base64")}.

PREVIOUS:

I see that you're using MongoDB Compass to query the field. Unfortunately, the current version of MongoDB Compass (v1.16.x) does not support querying binary data.

You can utilise mongo shell to query the data instead. For example:

db.collection.find({'_id':BinData(0, "WE8fSixi8EuWnUiThhZdlw==")});

Please note that the field name _id is reserved for use as a primary key; its value must be unique in the collection, and is immutable. Depending on the value of the binary that you're storing into _id, I would suggest to store the binary in another field and keep the value of _id to contain ObjectId.

edited Mar 7, 2020 at 5:02

answered Jan 21, 2019 at 1:30

Wan B.

18.9k4 gold badges60 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Trent Stewart Over a year ago

Thanks I managed to get it working by changing too to Robo 3T. This allowed me to query with binary. Thanks for your help.

Collectives™ on Stack Overflow

Querying Binary Field In MongoDB Compass

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related