title: Grafana only alert first error because condition state doesn't change
body: <p>I have a MSSQL query that monitor open transactions and returns me their open time in seconds, when some transaction is open for more than 10s, i send a notification. This works fine, but I'm having a problem is this scenario:</p>
  <ul>
  <li>A transaction is open for 5s and I open another one.</li>
  <li>Now I have two transactions, the first one with 5s, and the other one with 0s. When the first one reach 10s I will receive a notification, and the second will be with 5s.</li>
  <li>If both my transactions keep open when the second one reach 10s, i will not receive a notification, because the first one is still open.</li>
  </ul>
  <p>And that's the problem, I must get the notification in both cases.</p>
  <p>I've tried with the version v8.1.2(legacy alert), and v8.4.3(Unified alerting)</p>
  <p>I know the problem is because my condition doesn't change it's state: once one of my transactions reach 10s, its state become 1 (as show in the following image), and it will notify me again only when this state go back to 0, and then 1 again. But I don't kwon how to work around this problem.</p>
  <p><a href="https://i.stack.imgur.com/hNzK8.png" rel="nofollow noreferrer">https://i.stack.imgur.com/hNzK8.png</a></p>