Author Topic: No row data when writing a simple custom report type (Read 977 times)

matth · June 30, 2011, 01:29:02 pm

I'm trying to learn how to create a simple custom report type, but I can't figure out how to structure queries correctly. I created a basic SELECT statement, but the $rows are all empty arrays.

I'm not entirely sure what the

Code: [Select]

_columns variable is supposed to do, or if/how it affects what displays. Is there a way to bypass some or all of the structure? I simply want to list the results of a query.

Snipped of my query:

Code: [Select]

    function select( ) {
        $this->_select = "SELECT id, display_name";
    }

    function from( ) {
        $this->_from = "
        FROM civicrm_contact
        ";
    }

    function where( ) {        
        $this->_where = "WHERE id IN (1,2,3,4,5,6)";
    }

Rajan Mayekar · July 06, 2011, 10:45:19 pm

Hi,

Please refer this doc http://wiki.civicrm.org/confluence/display/CRMDOC32/CiviReport+structure+and+customization

Basically in your code u need to define column headers , generally we set it in select( )
So in your case it will be like

Code: [Select]

 function select( ) {
        $this->_select = "SELECT id, display_name";
        $this->_columnHeaders['id']['title'] = ts('Contact Id');
       $this->_columnHeaders['display_name']['title'] = ts('Display Name');
 }

Rajan

CiviCRM Community Forums (archive)

News:

Author Topic: No row data when writing a simple custom report type (Read 977 times)

matth

No row data when writing a simple custom report type

Rajan Mayekar

Re: No row data when writing a simple custom report type