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

Search Builder: Allow Different Record Types in Separate Criteria Sets (clauses) and Fix Operator Display in QILL

    Details

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

      Description

      Currently if you try to search on Individual fields in the 1st criteria set and Household (or Org) fields in the next set - you get this error:

      "Cannot have two clauses with different types: Individual, Household"

      While it makes sense to not allow mixing record types WITHIN a clause (criteria set) - since the result would always be NULL - we should allow different clauses (which are OR'd together) to use different record types. We support this in Advanced Search.

      So for example, I should be able to find Individuals (first clause) in California, also (OR) Organizations in California.
      ----------------
      Separate issue - some of the operators are not displayed in the QILL items correctly. Example: If you search for Birth Date > 19920101 - the qill item is:

      Birth Date - "January 1st, 1988"

      Note that there is a dash rather than a (>) operator in the string. The equal (=) operator seems to work for string comparisons but not for dates. Haven't tried numeric compares...

        Attachments

          Activity

            People

            • Assignee:
              kurund Kurund Jalmi
              Reporter:
              dgg David Greenberg
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: