Skip to main content

Quick question which may have an obvious answer ...

 

  • In Apps9 if I wanted to query for Part number does not begin with FT7 .. this is how I would achieve it

 

 

  • What’s the equivalent in Cloud?  I don’t seem to have any ‘not start with’ options.  Am I right in assuming it would be !FT72 and that that option is missing from the help list here?

 

Thanks!

Linda

Try         !~FT72%        I believe you will get everything but that in this case.

Hello !~FT72% will exclude any result that have ‘FT72’ in the searched values, if all your values start with FT72 and do not have it anywhere in the middle of the searched values then it’s ok. Otherwise use: 

(not startswith(PartNo,'FT72')) via advanced search 

Terms & ConditionsCookie settingsAccessibility statement