OroCommerce Forums

Covering OroCommerce topics, including community updates and company announcements.

Forums Forums OroCommerce I get no result at advanced search API

This topic contains 4 replies, has 3 voices, and was last updated by Andrey Yatsenko Andrey Yatsenko 8 months, 4 weeks ago.

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

  • Creator
  • #41122


    Hello, I am trying to use advanced search api, but I get no result at all queries i use, could you advise me what is wrong?
    that is example of query i use

    and that is full get request
    https://my url/admin/api/rest/latest/search/advanced?query=from customeruser where firstName ~ A

    the result is records_count = 0 and data is empty

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

    Yurii Muratov

    The search alias for CustmerUser entity is oro_customer_customer_user, not the customeruser.



    how can i know the alieses of all entities?



    After using oro_customer_customer_user it worked right
    but i need to know the aliases of all entities because i tried to search in product entity and i used that query

    i also get no result

    Andrey Yatsenko
    Andrey Yatsenko

    To know current entity aliases used in search you can use the search functionality in a management console, the top left corner. In the dropdown select an entity and click the search icon. Check the browser address bar for the URL, there you will see “from” statement with the correct alias.

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

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

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

Yes No