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

results of search with wildcard relationship match include phantom entries

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.7
    • Fix Version/s: 1.7
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      An advanced search for contacts with a relationship to contact '%' returns a list with all contacts with at least one relationship of the specified type. However actions on the results list also include contacts with no relationships specified.

      To recreate this on the demo:
      1. Ensure there is at least one Organization entry in the database with an 'Employee of' relationship to an Individual, and at least one Organization with no 'Employee of' relationships.
      2. Perform an advanced search selecting: Contact Type - 'Organization' AND Relationship of type 'Employer of' that matches '%'. Results will include all Organizations with at least one 'Employee of' relationship.
      3. Click the 'all X records' radio button and perform an action such as 'Add Contacts to a Group'. Now, the number of records is X + Y, where Y is the number of Organizations that didn't have any 'Employee of' relationships.

      I'm not sure what the desired results of matching a wildcard character in relationship matches is (i.e. do you want to included records that don't have any relationships? my thought would be no.) but the selected records should be consistent between the results page and the actions.

        Attachments

          Activity

            People

            • Assignee:
              shot Piotr Szotkowski
              Reporter:
              chrism Chris Mott
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: