Is there advanced condition in reports?

[MWright1]

Hi all,

I have a requirement to send a report to users with the following criteria:

sc_req_item table where a variable contains groups that start with "Business". 

This seems simple enough until I realize that we have about 81 groups that have names starting with that word.  My only option currently is ghastly - having to find the sys_id for each group and add them individually and build the condition.  

The more elegant way is IF we have an advanced condition builder, I can specify that the display name must contain "Business".  Does anyone have any idea if this is doable or an alternate way to do this without purchasing add-ons?

Thanks.

[Saurav11 · Accepted solution]

Hello,

You can create a script include and call the script include in the filter. Please check the below examples:-

https://www.servicenow.com/community/developer-forum/call-to-script-include-from-report-filter-doesn...

https://www.servicenow.com/community/it-service-management-forum/dynamic-filter-using-script-include...

https://www.servicenow.com/community/developer-forum/script-include-not-working-in-filters/m-p/22553...

Please mark my answer as correct based on Impact.