Author Topic: Need example of doing "UNION" within CiviReport (Read 1053 times)

SarahG (FountainTribe) · March 19, 2011, 08:58:56 pm

I am in the process of writing a new custom report.

I have already written and tested my SQL query ( which uses a UNION clause against CiviPledge and the CiviContribute tables) using PhpMyAdmin and it works as expected.

But I am struggling to get this working in my CiviReport. All the other report examples I have looked at use a single SELECT clause in their query, built in the function named "select( ) ".

Is there an example of a report that uses a UNION cluase that I could look at?

Rajan Mayekar · March 19, 2011, 09:37:52 pm

I don't think that currently any report that uses UNION clause. U need to override some function like select( ), from(), where() within your report and accordingly need to build the query.
variable $this->_columnHeaders is responsible to build report result columns.
Also Function alterRows( ), might help you to tweak the report result (ie display rows ) accordingly.

Rajan

Donald Lobo · March 20, 2011, 07:33:15 am

hey sarah:

implement your own

Code: [Select]

function buildQuery

instead of the select/where/from clauses. The framework will call that function and u can embed ant complex sql in there

lobo

SarahG (FountainTribe) · March 20, 2011, 11:01:33 pm

Thanks! That did the trick.

CiviCRM Community Forums (archive)

News:

Author Topic: Need example of doing "UNION" within CiviReport (Read 1053 times)

SarahG (FountainTribe)

Need example of doing "UNION" within CiviReport

Rajan Mayekar

Re: Need example of doing "UNION" within CiviReport

Donald Lobo

Re: Need example of doing "UNION" within CiviReport

SarahG (FountainTribe)

Re: Need example of doing "UNION" within CiviReport