Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-6354

_customGroupGroupBy not working for member summary in CiviReport

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.1.3
    • Fix Version/s: 3.2.1
    • Component/s: CiviReport
    • Labels:
      None

      Description

      See example at http://forum.civicrm.org/index.php/topic,13188.msg60534.html#msg60534

      Adding

      protected $_customGroupExtends = array( 'Contact', 'Individual', 'Household', 'Organization' );
      protected $_customGroupGroupBy = true;

      to CRM/Report/Form/Member/Summary.

      gives options to show and group by custom as expected but when trying to group by customGroupGroupBy creates bad SQL missing an aliased table name. Inserting the aliased table name lets the query succeed. See the above forum post for example code.

        Attachments

          Activity

            People

            • Assignee:
              ashwini Ashwini Poharkar
              Reporter:
              michaelmcandrew Michael McAndrew
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: