CRM-12251 CiviMember Reports Improvements: Inner Join On Type vs Status and Add "Primary Member"

          Details

          • Type: Improvement
          • Status: Done/Fixed
          • Priority: Minor
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.2.8
          • Fix Version/s: 4.4.0
          • Component/s: CiviReport
          • Labels:
            None

            Description

            1. If a member has two memberships, current type X and expired type Y, the contact will show in a report which asks for "all current members of type Y". That's cause they are 1) current and b) have type Y, but CiviReport is NOT joining the two data to provide an expected reporting result. This is probably a join that should be inner, or something like that.

            2. Add "primary member" vs "by relationship" vs "all" to membership reports, just as it is on Find Members

              Attachments

                Activity

                [CRM-12251] CiviMember Reports Improvements: Inner Join On Type vs Status and Add "Primary Member"
                Deepak Srivastava added a comment -

                #1 I couldn't reproduce and works fine. Probably its already been fixed.

                #2 v4.4 already has "Membership Owner ID" as a filter for membership detail report. When set to "empty" finds only primary members. Have also added this filter for membership summary report.

                Ravish Nair added a comment -

                Tested. Working fine.

                  People

                  • Assignee:
                    Ravish Nair
                    Reporter:
                    Stoob

                    Dates

                    • Created:
                      Updated:
                      Resolved: