OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

Forums Forums OroPlatform Advanced search oro_user where email = email@email.com

This topic contains 4 replies, has 2 voices, and was last updated by  Yevhen Shyshkin 7 years, 2 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
  • #36875


    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?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Author
  • #36876

    Yevhen Shyshkin

    Hello, ksharpie.

    For now exact equality operators (=, !=) fully supported only at Elastic Search engine in Enterprise edition. However your case is completely valid and we’ll fix it ASAP.



    I ran into this problem with elastic search as well. The default tokenizer breaks words at ‘@’.

    Thanks for the quick reply. Do you think this will make it into the April release?


    Yevhen Shyshkin

    I’ve tested two cases on ElasticSearch at clear installation:

    1) default search by all_text field – because this field uses nGram tokenizer “match” query will perform search by substring:

    Request: from oro_user where all_text = admin@example.com max_results 10

    2) search by specific field:

    Request: from oro_user where email = admin@example.com max_results 10

    Please, check content of ElasticSearch index (f.e. using kibana tool) and check requests passed to ElasticSearch.


    Yevhen Shyshkin

    > Do you think this will make it into the April release?
    We’ll try, but I can’t guarantee that.

Viewing 4 replies - 1 through 4 (of 4 total)

The forum ‘OroPlatform’ is closed to new topics and replies.

You will be redirected to [title]. Would you like to continue?

Yes No