addQuery operators

[swilson]

I'm trying to create Query business rule to limit the records being returned so I need to 'addQuery' to the current record where the field does not contain a specific string value. It looks like the operators 'CONTAINS' or 'STARTSWITH' are available but I need the opposite: DOES NOT CONTAIN or DOES NOT START WITH. Are there any operators defined for doing this?

Also, is there a list somewhere of what all the valid operators are for the addQuery method?

Thanks very much.

[john_roberts]

Here's an example of Short Description 'Does Not Contain' test

gr.addQuery('short_descriptionNOT LIKEtest');

[quote]Also, is there a list somewhere of what all the valid operators are for the addQuery method?
[/quote]If we did that we wouldn't be able to make ourselves look so good on the forums. 😄
I'll work on getting some info on the wiki, probably on the GlideRecord page.

[swilson]

Thanks very much.