Report with multiple OR statements

[Russ Heard3]

Hi, I need to replicate (or recreate...) many reports from our legacy tool to ServiceNow Helsinki.
One report is looking for tickets that have one of a long list (approx 40) of CI's as the Impacted Config Item.
Do I really need to separate these into individual OR statements, or is there a way of putting them in a list? The 'is one of' operand does not appear to be available on this column.

Thanks.

[amlanpal · Accepted solution]

Hi Russ,

Please go to the filter condition and use as Config Item-->Show Related Lists-->Name 'is one of' The values you want to filter.

I hope this helps.Please mark correct/helpful based on impact

[Russ Heard3]

Thankyou Amian - wondered where the 'is one of' had gone 🙂

Cheers

Russ