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.
PointValueQuery using where conditions
-
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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login