How can I find out how many incident does not have outage ?

Aryan
Tera Contributor

Hello All.

 

How can I find out how many incident does not have outage ?

3 REPLIES 3

Rhodri
Tera Guru

You should be able to do this with a related list condition in a report (you can then use the resultant query in a script):

 

Encoded query for any incidents with an outage:

RLQUERYtask_outage.task,>=1,m2m^ENDRLQUERY

 

Rhodri_0-1716904408700.png

 

You can change the greater than or equal to 1 condition to "none".

 

Rhodri_1-1716904647566.png

Encoded query:

active=true^RLQUERYtask_outage.task,=00,m2m^ENDRLQUERY

 

Aryan
Tera Contributor

can you share the screenshot of  related list conditions filter ??

While you're making your report you have to click on "related list conditions" to expand it, once expanded you can can choose the table (outages) and change matched records to none. You won't need a filter because you are looking for anything unrelated to any outages.

 

Does that make sense?

 

Screenshot_20240528-152351.png