How to create "Not Start with" condition in filter

[louisth]

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".

Best regards,

Kobboon Suksakorn

[Ajai S Nair · Accepted solution]

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

[louisth]

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