Forum Discussion

marting's avatar
marting
Icon for Neophyte rankNeophyte
6 days ago
Solved

Complex Datapoints - Nested if / elseif possible w/o scripting?

Setting up some monitoring for an HVAC device and there is a request to track / alert on the current state/mode of HVAC zones (i.e. when they're not at the expected state). There is an HTTP interfac...
  • Stuart_Weenig's avatar
    Stuart_Weenig
    6 days ago

    Groovy can't access the normal datapoints, but it has the output of the script. So you could use Groovy to loop through all the lines, splitting on the ":" and grabbing the datapoint name and value into a map. 

    Nested if statements are definitely possible. Most likely there's a problem with opening/closing parenthesis.

    However, I wonder if you can do this with a script pretty easily.

    statusMap = [
  "Heat": 1,
  "Cool": 2,
  "Vent": 3,
  "On Fire": 4,
  "This is OK": 5,
  "Batman riding an elephant": 6,
  "Day after tomorrow": 7
]
data = new URL("https://myACunit/metrics").getText()
value = data.tokenize(":")[1]
println("mode: ${statusMap[value]")

    Then you'd only have one datapoint and that one datapoint would have an integer value depending on the mode returned.

Stuart_Weenig's avatar
Stuart_Weenig
Icon for Mastermind rankMastermind
6 days ago

Groovy can't access the normal datapoints, but it has the output of the script. So you could use Groovy to loop through all the lines, splitting on the ":" and grabbing the datapoint name and value into a map. 

Nested if statements are definitely possible. Most likely there's a problem with opening/closing parenthesis.

However, I wonder if you can do this with a script pretty easily.

statusMap = [
  "Heat": 1,
  "Cool": 2,
  "Vent": 3,
  "On Fire": 4,
  "This is OK": 5,
  "Batman riding an elephant": 6,
  "Day after tomorrow": 7
]
data = new URL("https://myACunit/metrics").getText()
value = data.tokenize(":")[1]
println("mode: ${statusMap[value]")

Then you'd only have one datapoint and that one datapoint would have an integer value depending on the mode returned.

  • marting's avatar
    marting
    Icon for Neophyte rankNeophyte
    5 days ago

    Thanks Stuart!  You were right: I must've had one too many/few parentheses/commas sprinkled in...  Got the expression to work by doing the following:

    if(eq(ZoneModeHeat,1),5,  if(eq(ZoneModeDry,1),4,  if(eq(ZoneModeFan,1),3,  if(eq(ZoneModeCool,1),2,  if(eq(ZoneModeAuto,1),1,0)  )  )  )  )

    If I get the time, might look at converting to groovy as that would be significantly easier to read.