ssossossosso

Forums

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

This topic contains 2 replies, has 2 voices, and was last updated by golriz.nourani golriz.nourani 1 year, 8 months ago.

  • Creator
    Topic
  • #15829
    golriz.nourani
    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
  • #15865

    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.

    #15867
    golriz.nourani
    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)

You must be logged in to reply to this topic.