DOES NOT START WITH filter

[Anish Reghu]

Dear all,

This was asked 5 years ago, unanswered. Asking it again to a much wider audience now, hopefully.

Can someone suggest that script include for DOES NOT START WITH and how to call that from a advanced filter? Please don't refer me to threads, even the thread marked as RESOLVED does not have the solution in it. Any help is appreciated.

I know one solution is to create a advanced filter and calling a script include. But I would need the solution instead of the approach.

Any answers?

Regards,

Anish

[DirkRedeker]

Hi

Do you have an update on this question? Were you able to sort it out?
If you were able to solve your issue, just let me know and mark the best answer as correct and helpful.
This will close this thread and help others to benefit from the outcome.

Thanks & BR
Dirk

[Filip Vojt__ek · Accepted solution]

Hi Anish,

it's a while ago, but maybe someone will find this answer helpfull.

The solution from my point of view is to use SQL 'LIKE' operator which work even though it's not documented for GlideRecord:

gr.addQuery('name', 'NOT LIKE', 'StartString%');

Pls mark as helpful if solution works.

[Anish Reghu]

Coincidentally I found the same as solution today on another forum. Thanks for responding.

[Community Alums]

Anish, what was that solution??

[Luiz Lucena]

Wouldn't be "Does not contains" the equivalent of that?