NRQL queries to find only open incidents now

Hello Team,

How to do join or filter with the output of other queries in NRQL,
I would like to build a query which will give me the current open incident list.

Hi there @arijit.chowdhury -

I took a look at this for you and I don’t think there is a straighforward way to do this, per this thread:

Let me know if you have more questions after reviewing that thread, or if I misunderstood what you are trying to do!

Hi, @arijit.chowdhury: You may find this post helpful: