IFS Cloud Search Syntax for multiple "not equal" criteria

In Apps 10 Aurena and IFS Cloud, to perform a “does not equal” search we don’t use “<>” but instead use “!=”. The following advance search should therefore give you the required results…

((PartNo != '123') AND  (PartNo != '456'))

I would note that you can click on the little question mark within the search tool to see a list of all available search parameters…

(I would also note that “;” is used for OR. I assume you actually want AND which cannot be done in standard search. My preferred work around is to use standard search using ; for OR then click Advanced and manually edit the search text to change OR to AND).

• Robin

(Same company as Anna above who asked the question). 

Thanks Robin! We were using the “!=” for not equal to - sorry that wasn’t clear. However, your comment about changing the ORs to ANDs works perfectly for what we’re trying to do.

I’ll let Anna confirm just in case because I came across this post separately actually, but this works for me!

Thanks!

Thanks, Robin.  That’s what I feared, but anticipated.

Searching definitely took a step backwards as it was:

 

IFS 8: 

<>123;<>456;<>789

IFS 10:

<>123;456;789

IFS Cloud:

(CatalogNo != '123') AND (CatalogNo != '456') AND (CatalogNo != '789')