OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

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 Yevhen Shyshkin 4 years, 7 months ago.

  • Creator
    Topic
  • #36875

    ksharpie
    Participant

    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
    Replies
  • #36876

    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.

    #36877

    ksharpie
    Participant

    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?

    #36878

    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 = show email max_results 10
    Response:

    2) search by specific field:

    Request: from oro_user where email = show email max_results 10
    Response:

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

    #36879

    > 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)

You must be logged in to reply to this topic.

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

Yes No