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

contribution detail report: error when sorting by custom contrib field

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.6.8
    • Fix Version/s: 4.7
    • Component/s: CiviReport
    • Labels:
    • Documentation Required?:
      None
    • Funding Source:
      Core Team Funds

      Description

      to reproduce, create a custom data set for contributions. create a field and mark it searchable.

      create a new contribution detail report and choose this field in the sort options.

      • if the field is not selected in the column settings, you receive an unknown column error
      • if the field is selected in the column settings, you receive a duplicate column name error

      it seems in the first case, the problem is that the custom data table is not included in the FROM joins. in the second case, it's adding the column once for display and once for sorting purposes.

        Attachments

          Activity

            People

            • Assignee:
              jitendra.purohit Jitendra Purohit
              Reporter:
              lcdweb Brian Shaughnessy
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: