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

Event - Find Participants does not return any results when a price set is used

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.3.5
    • Fix Version/s: 4.4.0
    • Component/s: CiviEvent
    • Labels:
      None

      Description

      When using a price set for an event, all selected items are stored in civicrm_participant.fee_level. CRM/Event/BAO/Query.php looks for an exact match.

      For example, if your event has multiple price set items and one is a meal choice for "Tuna Salad", when searching for participants that ordered the Tuna Salad, no participants are found.

      The attached patch changed the query to wildcard the search term in the query.

      (This was reported to Dave Greenberg at the CiviCamp in Washington, DC.)

        Attachments

        1. search-by-fee-level.diff
          0.4 kB
          Dan O'Brien
        2. search-by-fee-level.patch
          0.8 kB
          Dan O'Brien

          Activity

            People

            • Assignee:
              yashodha Yashodha Chaku
              Reporter:
              axon-obriend Dan O'Brien
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: