OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

This topic contains 2 replies, has 2 voices, and was last updated by  golriz.nourani 8 years, 2 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
  • #34039

    golriz.nourani
    Participant

    Hi
    Is there any way to use native query for gathering data of a data gridview?
    thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Author
    Replies
  • #34040

    Rodolfo
    Participant

    Do you really need native query? I ask because I had the same problem once when I wasn’t able to get some data using datagrid.yml. I asked here on Forum and some guys helped me to create some custom hacks.

    #34041

    golriz.nourani
    Participant

    I want to generate diverse report and any of them have complex query so I need a way to run native query some times for example this one is a below

    select q1.c1 q2.c2 as value
    from
    (select sum(t1.c) as c1, c5 from table1 t1 …. group by c5 ) as q1
    left join
    (select sum(t2.c) as c2, c4 from table1 t2 …. group by c4 ) as q2
    on q1.c5=q2.c4
    where …..

    thanks

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

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

Back to top