Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Reverse where clause

Highlighted
Stefan Sagstett
Super Collector

Reverse where clause

Hello,

Service Pages. Is it possible to have a where-clause that searches the opposite of the String filled in?

For example I now have something like that, for searching anything that contains the string "On Demand Service":

serviceWhere.addContainCriteriumOnText("On Demand Service");

And this line of code three times for all text I want to have.

It would be nice to do a addContainNOTOnText or something else to search anything that doesn't contain the given string.

So is there a possibility to do something like that?

Greetings,
Stefan
2 REPLIES
Ruth Porter
Honored Contributor

Re: Reverse where clause

Hi Stefan,

If you go to the advanced tab of the filter you will see that the operator "doesn't conatin2 is available for string fields.

Hope this helps

Ruth
http://www.teamultra.net
Ruth Porter
Honored Contributor

Re: Reverse where clause

Hi Stefan,

If you go to the advanced tab of the filter you will see that the operator "doesn't contain" is available for string fields.

Hope this helps

Ruth
http://www.teamultra.net
//Add this to "OnDomLoad" event