​@smoore10 change your operator ‘<>’, you can use the option available for your control type

Thanks Phillip,

When I use !~%barrday%;%subcontractor%;%jason%;%michael%;%richard% this does not work either. 

Hence me struggling. I have tried almost everything, and I am starting to think that I just can not filter this way in Cloud… 

Hi ​@smoore10,

!~ would only be used for does not contain filter, and there is no need to use % sign with it.

for example, Business users want to query all Customer records excluding barrday, then in that case, they simply need to enter !~barrday only in the name filter. Please check like this.

You can use Advanced search as well if the above suggestion does not work. Please refer to the screenshot below.

Regards

Abdul Rehman

​@smoore10 once you have search criteria specified use the ‘Advanced’ link to see what Odata query your search is returning.

I think the ‘<>’ operator in IEE applied to the entire line. In cloud each item in your OR clause the default search for those items is used unless a different one is specified for each item

To get your search to work for all of those, you will need to alter the advance search to change OR to AND

Heres an example

Hello,

i put the filters as you said. The results still have customer’s with ‘barrday’ in their name. 

​@smoore10 check that you have disabled the “Match Case” button on the filter

 

​@smoore10, something is missing. 

Can you please copy and paste below query directly in Advanced search, and then check results.

(not contains(tolower(Name),'barrday'))

​@PhillBronson 

if i want to filter for a customer, but do not want to type their full name, example: ‘Barrday’ instead of ‘Barrday Corporation’, how would i do that in Cloud. In 10 you would use the % so signify anything that has these letters or numbers, but it doesnt seem like that is the case anymore. 

​@smoore10 you would use the Contains option.

You are very close already

I think you have Match Case enabled (I can tell from the result returned in your Advanced Search...it is not homogenizing the text with the use of ‘tolower’)

I seem to have the same issue when enter multiple values. 
 

((not contains(tolower(Description),'order')) OR (not contains(tolower(Description),'demo')))

It still populates all values where the description contains ‘order’ and ‘demo’. 
 

Searching for one value works as expected. 

​@COVJAMIEB yes, apparently you have to go into the Advanced filters, and where it has “OR”, you have to delete it and write “AND”, which seems like a one time solution, but not a long term solution to filtering multiple things at once.

​@PhillBronson I do not have match case one anymore, and I am able to filter using the “OR”/”AND” correction in the advanced filter, but… is this really the solution to filtering multiple things at once? I am assuming that “;” means “OR”, do we know what “AND” is represented by in basic filters? 

​@smoore10 yes as far as I can tell...but its ok you’ll have many more differences from IEE that you’ll forget about this