Query the employees who are in lunch status for more than an hour

we store employee current status in influx , and employee status as field I want to query all the employees who are in lunch status for more than an hour and want to raise alert for this . how can we do that ?

Hello @monikagupta,
Welcome.
Here’s some docs on creating alerts with flux and using functions that could be helfpul:
Some docs on how to create an alert task which provides the most flexibility when creating alerts:

stateduration function in flux for monitoring the duration of a state:
stateDuration() function | Flux Documentation.
Alert docs:
Monitor data and send alerts | InfluxDB Cloud (TSM) Documentation