How to create a GlideRecord Query for NOT STARTSWITH

[Rajanmehta]

Hello

We are on Jakarta. I have a need to filter out IP address which starts with 172.

How can I add to my query? Any help on syntax would greatly appreciated.

rec.addQuery('ip_address', 'STARTSWITH','172.');   ( I want to add query like this but with negation i.e. Does not Starts with)

Thanks,

Rajan Mehta

[Rajanmehta]

Shishir,

By the way I am not seeing option to mark your answer as correct.

Thanks,

[Shishir Srivast]

Please hit this link: How to create a GlideRecord Query for NOT STARTSWITH and you should be able to see the option to mark it correct.

for more details: How To Mark Answers Correct From Community Inbox

[Rajanmehta]

I am not seeing option for correct answer. I think it was started as discussion by mistake. Can we convert it into question and how?

[Shishir Srivast · Accepted solution]

Hi dan.bruhn,

Please help to convert this post from discussion to question. Thank you for your help.

[Dan Bruhn]

Hi Shishir,

This has been converted into a discussion.

Thanks,