[Bug]-[2800]:BinData from MongoDB is not recognized

[ghost]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

When I query MongoDB from Appsmith and try to use BinData the editor does not recognize the function.

Photo provided by discord user Fouad#2407:

I expect BinData to work as intended inside of MongoDB queries.

Steps To Reproduce

1. Create a new Appsmith project.
2. Add a MongoDB data source.
3. Use new BinData() during the query.
4. Observe that the function is not recognized.

Public Sample App

No response

Version

Cloud 1.6.17

[MarabiFouad]

I want to build a list of _id objects inside Or operator array based on selected rows in the table.

[Nikhil-Nandagopal]

@MarabiFouad BinData should be a string here "new BinData(${row._primary_key})"

[MarabiFouad]

{ "update": "orders", "updates": [ { "q": { _id:{ $in:[\"new BinData(03,\"aCpgBChCHUC1pxBlmRmNsQ==\")\",\"new BinData(03,\"57odwItZ5ka3AqybWRCkXw==\")\"] } }, "u": { "$set": { "Comment.Status": 2 } }, "multi": true } ] }

I still have an issue above code is the evaluated code but it is string and does not work

[MarabiFouad]

$in:["new BinData(03,"aCpgBChCHUC1pxBlmRmNsQ==")","new BinData(03,"57odwItZ5ka3AqybWRCkXw==")"] It should look like below $in:[new BinData(03,"aCpgBChCHUC1pxBlmRmNsQ=="),new BinData(03,"57odwItZ5ka3AqybWRCkXw==")]

[sumitsum]

Re-opening this issue since the user has reported that their issue is not resolved.

[rohan-arthur]

mongo 6m usage: 700 assume 50% requirement: 350

[ajinkyakulkarni]

Stats

Stat	Values
Reach	350
Effort (months)	0.25