How to create "Not Start with" condition in filter

louisth
Kilo Contributor

Hi all,

I would like to filter out some data by using "Not start with" condition and could not find them from OOB filter options.

Is there a way to apply this condition to custom filter?

For example, I tried to filter the name that does not start with "ISS".

Filter.jpg

Best regards,

Kobboon Suksakorn

1 ACCEPTED SOLUTION

Ajai S Nair
Giga Guru

Hi Kobboon Suksakorn,




Normally we don't have a filter to check using "Not start with" but you can write a script include and call that from the filter. The below link will help you for that


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



Hope this will solve you issue


View solution in original post

2 REPLIES 2

Ajai S Nair
Giga Guru

Hi Kobboon Suksakorn,




Normally we don't have a filter to check using "Not start with" but you can write a script include and call that from the filter. The below link will help you for that


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



Hope this will solve you issue


Hi Ajai,



Good to know that we could create the advanced filter from Script Include.



But for this case, it's quite complicated and not flexible for users.


So, I might add additional field in the form for users to avoid adding some prefix in the normal text box.



Anyway, thank you very much.



Best regards,


Kobboon