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

[Shishir Srivast]

can we try with NOT LIKE

[Rajanmehta]

hi Shishir,

I tried that, but unfortunately it doesn't filter correctly.

Thanks for your response though.

Thanks,

[Shishir Srivast]

what is your exact requirement, can you please explain?

[Rajanmehta]

Exact requirement is to filter out hosts which IPs starts with 172. (Want to exclude that subnet)