How to Build filter "Not Starts With" ? For example show all users whose user ID not starts with U

[sureshyadagiri]

Hello,

I am new to Service Now. trying to build reference qualifier for users. How to build a filter for "Not starts With" ?

Thanks,

Suresh      

[SanjivMeher]

There is no such filter. You can write a script include and call it in here

http://wiki.servicenow.com/index.php?title=Using_Filters_and_Breadcrumbs#Scripted_Filters

[sureshyadagiri]

Thanks Sanjiv. if OTB not available, this is one option. I was thinking of any performance issue comes here if we write a dynamic filter.

I will give a try.

[SanjivMeher]

If you table is not huge, it shouldn't be a problem. Otheriwse I would recommend running it during off-business hours.

[sachin_namjoshi]

Please refer below post which will resolve your issue.

How to create one custom filter "NOT Start with"

Regards,

Sachin