ISSUE IS SOLVED!
I opened up a ticket with customer support and was provided with the correct formatting for my query:
{{^Query={"accountInfo.companyOwnerId": "1"}^}}
So, I simply needed to embed the query above between { } for my "Query for Mongo DB" Node to funtion.
I really appreciate the support team's help!
Tom T.
------------------------------
Tom Tannehill
CenturyLink
Monroe LA
------------------------------
Original Message:
Sent: 10-01-2025 13:44
From: Tom Tannehill
Subject: Query for Mongo DB Node Questions
In the first block of Input data on this node I have been selecting Query (from Query) drop-down and inputting "{{^Query=^}}" (without double-quotes).
This has been working fine for pulling the entire collection. However, I've yet to figure out how to query the collection to pull a filtered-down version.
I would like to run the following query:
db.collection.find({
"accountInfo.companyOwnerId": "1"
})
If anyone has an idea how to format this query within the "Query for Mongo DB" node, it would be much appreciated.
Thanks!
Tom Tannehill: Lumen Technologies
------------------------------
Tom Tannehill
CenturyLink
Monroe LA
------------------------------