Data type esctructure

Hi, can you help me? I need to write about the value of an alarm based on the activation of another alarm, I am working with one (newexpresiontag), in the option of “Expersion” I am writing the status of the alarm.

But I get left bracket error.

Take the 2000 out of the brackets.

Hi, MMaynardUSG.

I need to add the number of times that a larm was active during a period of time of work, that is if the alarm was activated 10 times in the day, I want to count those times and write that value in a new tag.

You would have to query the alarm tables to get that information
Something like this

SELECT
a.displaypath,
COUNT(*) total
FROM
alarm_events a
WHERE
a.eventtime
BETWEEN ‘3/19/2018 00:00:00’ AND ‘3/20/2018 00:00:00’
AND a.eventtype = 0
AND a.displaypath = ‘Your Alarms Displaypath’
GROUP BY
a.displaypath
ORDER BY
total DESC

1 Like

HI, MMaynardUSG
I do not want to count how many alarms were generated, if not the total time an alarm was active

I want that information in a report.