How can I get only specifics itens from a list with OData, I want to get any e-mail domain but not a specific one. So, in this list I have some e-mails but I wanted to filter with OData to not get the people with certains domains.
I tried this but had no success.
Thanks in advance.
Solved! Go to Solution.
I believe that "not" will not work in a odata filter
Look here:
Hi
What does the error message return?
The statement looks correct.
What column type is the email column?
Hi!
The type of the column is a Single line of text.
After testing again, the error doesn't seems to appears again...
But what I am trying to do is not get a specific e-mail domain. When I add the operator not before the statement (not substringof('@example.com.br',EMAIL_x0020_RESPONSAVEL)) an erro occurs.
This is the error:
Fetching items failed. Possible invalid string in filter query.
clientRequestId: 3364b922-3971-4df7-9bbc-344a3474a2c2
serviceRequestId: 3364b922-3971-4df7-9bbc-344a3474a2c2
I believe that "not" will not work in a odata filter
Look here:
User | Count |
---|---|
16 | |
16 | |
14 | |
9 | |
8 |
User | Count |
---|---|
27 | |
26 | |
24 | |
23 | |
14 |