+1Hello,
We are in the process of switching from IFS10 to Cloud. I am confused by the filtering. In Apps10, if I wanted to exclude certain customer names I would use this filter: <>%barrday%;%subcontractor%;%jason%;%michael%;%richard%
Now in Cloud, this filter is not working. How would I type out the same thing in Cloud to ensure that the above are excluded? Also, does the % not hold the same purpose in Cloud?
Best answer by PhillBronson
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
+11
+1Thanks 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…
+20Hi
!~ 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
+11
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
+1Hello,
i put the filters as you said. The results still have customer’s with ‘barrday’ in their name.
+11
+20
Can you please copy and paste below query directly in Advanced search, and then check results.
(not contains(tolower(Name),'barrday'))
+1
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.
+11
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’)
+11I 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.
+1
+11
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
