Hi Beau,
If you have the email address you want to filter with using field ID 35, you can use the HAS query:
{"from": "TABLEIDHERE","where": "({36.IR.'today'}OR{36.IR.'yesterday'}) AND ({35.HAS.'rudolphemail@email.com'}OR{35.HAS.'jackemail@email.com'})","select": [3,3148,3143,3133,36,35,401,3149,3147,3130],"sortBy": [{"order": "DESC","fieldId": 36}],"options": {"top": 0,"skip": 0,"compareWithAppLocalTime": false}}
I hope that works! Let me know if not.
Here is a snippet of the documentation on the HAS Query:
|
HAS
|
Contains a specific set of users. Used with list-user fields only.
For each user you are trying to find, you must enter the user's ID, user name, or email address. You can also enter placeholder names. Be sure to surround placeholder names with double quotes.
The query parameter must be surrounded by single quotes.
Separate users in the list using a semi-colon.
For example:
<query>{'6'.HAS.'-8675309; -9873297'}</query>
|
------------------------------
Sean Connaughton
------------------------------
