OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

This topic contains 1 reply, has 2 voices, and was last updated by msulima 6 years, 7 months ago.

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

Creator
Topic
August 29, 2017 at 11:32 pm #34462

golriz.nourani
Participant
Hi Dears
I have a complex select for datasource of my datagrid . I can not supply data by query builder . is there any way to use native query to supply datasource of datagrid?
Thanks
Golriz
Creator
Topic

Viewing 1 replies (of 1 total)

Author
Replies
August 30, 2017 at 8:50 am #34463
msulima
Moderator
Hi, golriz.nourani. Thank you for your question.
Unfortunately you can’t use native SQL query for datagrid configuration.
- use event oro_datagrid.orm_datasource.result.after to add some additional data to grid result
  See an example: https://github.com/orocommerce/orocommerce/blob/master/src/Oro/Bundle/PricingBundle/EventListener/ProductPriceDatagridListener.php#L94
- write custom datasource, but resolving issues with sorters and filters may take some time
Check our free technical guide ”How to Build a Reliable and Secure Infrastructure for OroCommerce”.
Author
Replies

Viewing 1 replies (of 1 total)

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

Back to top