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

Contribution Search Query includes all custom fields

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.0.7
    • Fix Version/s: 4.1.0
    • Component/s: CiviContribute
    • Labels:
      None

      Description

      http://forum.civicrm.org/index.php/topic,22572.0/topicseen.html

      The query for contribution search performs a left join on every custom field (not just those related to contributions).
      It also joins relationship fields and activity fields.

      From what I can tell, all of these joins are unnecessary since none of this information gets displayed in the search results (including custom contribution fields).

      Ironically...
      I recently implemented the new hook_civicrm_searchColumns() to pull some custom data into contribution search results. Despite all the above-mentioned joins, no custom data was available for the contribution objects passed to that hook, so I had to run a separate query in my function to grab it.
      If you decide not to get rid of the contribution custom field joins, I would request that the information actually gets read into the objects instead of discarded.

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              colemanw Coleman Watts
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: