• Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

    SQL Data Source - Is it possible to include a Data Point value in a query?

    Mango Automation general Discussion
    3
    4
    660
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      andrewh last edited by

      Hi

      I'm running mango 3.5.6

      I am creating a set of queries for SQL Data Sources. I'd like to know if it's possible to include the value of a data point in the query. The concept is like a parameterised query. eg use the value of a data point in a where clause - like "Select "First_name from Employees where empno = [DataPointx.value]".

      1 Reply Last reply Reply Quote 0
      • A
        andrewh last edited by

        Any ideas?

        1 Reply Last reply Reply Quote 0
        • Jared Wiltshire
          Jared Wiltshire last edited by

          This post is deleted!
          1 Reply Last reply Reply Quote 0
          • terrypacker
            terrypacker last edited by

            You cannot do this on the query but you could do it on the update statement for the point. The setting of the SQL data point's value could be done via a Meta or Scripting data source. The help docs on the data source should get you going.

            1 Reply Last reply Reply Quote 0
            • First post
              Last post