Search Query Syntax

[nick.wright]

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]

No, there is not.

[nick.wright]

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"
  ]
}

]