ssossossosso

Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

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

  • Creator
    Topic
  • #9462

    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
  • #9463
    Yevhen Shyshkin
    Yevhen Shyshkin
    Oro Core

    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.

    #9464

    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?

    #9468
    Yevhen Shyshkin
    Yevhen Shyshkin
    Oro Core

    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
    Response:

    2) search by specific field:

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

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

    #9472
    Yevhen Shyshkin
    Yevhen Shyshkin
    Oro Core

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