Skip to content

Activity Type and Case Type not being combined correctly in Advanced Search

Steps to create (5.29)

  • Create CaseType1 containing a Meeting
  • Create CaseType2 containing a Meeting
  • Create a Case for Contact_A of CaseType1
  • Create a Case for Contact_A of CaseType2

Advance Search: Display: Activities, Logical_Operator: AND, Activity Type: Meeting, Case Type:CaseType1

Search description displayed:
Activity Type ID In Meeting ...AND...
Activity targeted to ...AND...
Case Type(s) In CaseType1 ...AND...
Case = All Cases

Actual Result (two meetings returned instead of one):
Meeting (from CaseType1)
Meeting (from CaseType2)

Nothing I tried enabled me to exclude the Meeting in CaseType2. If a Contact had Cases of both CaseType1 and CaseType2 all their Meetings were reported in the results and the Case Type filter did not work.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information