• Recent
    • Tags
    • Popular
    • Register
    • Login

    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 Mango 5 Documentation Website

    PointValueQuery using where conditions

    Scripting general Discussion
    mangojavascript pointvaluequery
    1
    1
    535
    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
      ar
      last edited by ar

      Hi All,

      I am trying to get a sum of PointA for defined period where the value of PointB meets a given condition. These Point A and B are logged at the same interval.

      e.g. if it was SQL Statement, I believe it would be something like below
      SELECT SUM(PointA)
      FROM TableName
      WHERE PointB IN (1,5);

      Is it possible to put a condition in the PointValueQuery object or is there any other way to achieve this?

      Thanks.

      AR

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