I am using the advanced query api to find platform Users via email address.
I believe “from oro_user where email = $email” should only return one result; however it is returning many results and the email for the entities returned are not equal to the email.
If I run “from oro_user where email ~ $email” then fewer results are returned (including the one that I am looking for) but the rest of the results are wrong.
What am I doing wrong? Am I searching the wrong entity?
You must be logged in to reply to this topic.