I get no result at advanced search API

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

PHP

query=from customeruser where firstName ~ A

1	query=from customeruser where firstName ~ A

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

Topic

[Yurii MuratovParticipant]

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

[asmaa.tahoon25Participant]

how can i know the alieses of all entities?

[asmaa.tahoon25Participant]

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

PHP

from oro_product_product where name ~ 'test'

1	from oro_product_product where name ~ 'test'

i also get no result

[Andrey YatsenkoModerator]

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.

[Author]

Replies