Data360 Analyze

 View Only
  • 1.  Query for Mongo DB Node Questions

    Posted 10-01-2025 13:45

    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
    ------------------------------


  • 2.  RE: Query for Mongo DB Node Questions

    Posted 10-06-2025 06:41

    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
    ------------------------------