MongoDB - Expression Binding - Filter

Ignition
,
1

I am working with the MongoDB Module connected to FANUC MTLinki:
I am struggling to get the MongoDB Expression Binding to work correctly with filtering dates.

I can get the script to work properly.

Any help is appreciated!

Sample Data from MongoDB:

{ "_id": { "$oid": "12345678" },
 "L1Name": "HAAS_321", 
"updatedate": { "$date": "2024-10-28T13:40:00.000Z" }, 
"enddate": { "$date": "2024-10-28T13:52:26.000Z" }, 
"timespan": 746, 
"signalname": 
"condition",
 "value": "DISCONNECT",
 "filter": null, "TypeID": null, "Judge": null, "Error": null, "Warning": null }

image
image568×280 16.5 KB

2

I haven't used this module in Ignition before, but were you able to use MongoDB Compass to confirm that the find filter is valid? If you do that, then you are sure it's a syntax issue with the binding in Ignition.

3

Yes. I have verified the filter in Compass and the syntax worked there:

I headed down a path of setting the filter as an object but it did not work.

image
image912×376 41.3 KB

4

Any update on this? Im having the same issue and I cant find any documentation on how to apply filters this way.

5

Apologies on the delayed response. I was not able to get the filtering to work as desired. I need to revisit when I have some time. If you have some success please post your findings.