CRM-8186 Making a report that filters on custom data throws an error if that data is not displayed

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Minor
          • Resolution: Duplicate
          • Affects Version/s: 3.3.6
          • Fix Version/s: 4.1.0
          • Component/s: CiviReport
          • Labels:
            None

            Description

            Making a custom report from the constituents summary template, I used a custom field to filter (IS NULL), but didn't include it as a display column. This led to an 'unknown column' error because the query did not have a left join to the custom data table.

            Adding the field as a display field caused the left join to be added and the report to display.

              Attachments

                Activity

                [CRM-8186] Making a report that filters on custom data throws an error if that data is not displayed
                Donald A. Lobo added a comment -


                Can you investigate and provide a patch, we can help u get started on IRC

                Rajan P Mayekar added a comment -

                Hi,
                This issue is already fixed under following issue:
                http://issues.civicrm.org/jira/browse/CRM-8312

                Here is the patch:
                https://fisheye2.atlassian.com/viewrep/CiviCRM/branches/v3.4/CRM/Report/Form.php?r1=34882&r2=34892

                Thanks,
                Rajan

                  People

                  • Assignee:
                    Rajan P Mayekar
                    Reporter:
                    Matt Gibson

                    Dates

                    • Created:
                      Updated:
                      Resolved: