nick.wright | 2023-08-11 13:46:27 UTC | #1
I have this search API query:
{ "pageSize": 25, "pageNumber": 1, "types": [ "users" ], "returnFields": [ "name", "email" ], "query": [ { "group": [ { "type": "EXACT", "value": "xxx.oneill@xxx.co.uk", "fields": [ "email" ], "operator": "OR" }, { "value": "xxx.savage@xxx.co.uk", "type": "EXACT", "fields": [ "email" ], "operator": "OR" } ] } ] }
I need to query around 80 email addresses, so rather than 80 ORs, is there an equivalent of the SQL "IN" statement, so I can just do a list of all 80 email addresses?
Eos_Rios | 2023-08-11 13:32:23 UTC | #2
No, there is not.
nick.wright | 2023-08-11 13:45:58 UTC | #3
thanks. Ended up doing it like this:
"query": [ { "operator": "OR", "values": [
"xxx.mcmonnies@xxx.co.uk", "xxx.hickey@xxx.co.uk", "xxx.boardman1@xxx.co.uk", "xxx.burgess@xxx.co.uk", ...
], "type": "EXACT", "fields": [ "email" ] } ]
system | 2023-09-11 13:46:55 UTC | #4
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 21475