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


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


      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...




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


              • Created: