CASE
WHEN LOWER(users.employeeid) NOT LIKE '%non human%'
THEN
(accounts.customproperty1 = users.employeeid)
OR (accounts.name = users.email)
OR (accounts.customproperty26 = users.email)
OR (accounts.customproperty25 = users.email)
END
Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.
