MongoDB newbie here.
I’m currently working on a collection with the following format and would like to query using one of the Binary Data (BinData) fields (field 7 specifically).
{
"_id": { "$oid": "638c9d85dc421ca10535a4eb" },
"address": { "$binary": { "base64": "Aps+Wi0+ohSeEgdWOdFntRB9CfPDnRadImqBE0xeCm8=", "subType": "00" } },
"data": [
{ "$binary": { "base64": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAc=", "subType": "00" } },
{ "$binary": { "base64": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ=", "subType": "00" } },
{ "$binary": { "base64": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAE=", "subType": "00" } },
{ "$binary": { "base64": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGOMWbw=", "subType": "00" } },
{ "$binary": { "base64": "BKCnUajHGjeljritGFmov3Y1Nxe+qzHhdt5czHxU25g=", "subType": "00" } },
{ "$binary": { "base64": "BKCnUajHGjeljritGFmov3Y1Nxe+qzHhdt5czHxU25g=", "subType": "00" } },
{ "$binary": { "base64": "Ar8yb5wiJOp6IG2lEiOLMUugf4suTlnhAdqoO42xkBg=", "subType": "00" } },
{ "$binary": { "base64": "BQ/n841SdqelP31SXwi8k72MN8DbMY/LaPJOPSkoOSU=", "subType": "00" } },
{ "$binary": { "base64": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAABGeR/ITgfQAAA=", "subType": "00" } },
{ "$binary": { "base64": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABvBbWdOyAAA=", "subType": "00" } },
{ "$binary": { "base64": "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABvBbWdOyAAA=", "subType": "00" } }
],
"name": "log_buy_filled",
"_chain": { "valid_from": { "$numberInt": "20336" }, "valid_to": null }
}
I have tried the following queries but none of them work:
import { Binary } from "mongodb"
const documents = await db.collection("events").find({
name: "log_buy_filled",
"data.7": new Binary("BKCnUajHGjeljritGFmov3Y1Nxe+qzHhdt5czHxU25g=", 0)
})
const documents = await db.collection("events").find({
name: "log_buy_filled",
"data.7": { "$binary": {
"base64": "BKCnUajHGjeljritGFmov3Y1Nxe+qzHhdt5czHxU25g=",
"subType": "00"
}
})
What is the correct way to query BinData using JavaScript?