Constituents missing from query results when querying for Constituent records with Assigned Solicitor relationships that are not a specific Solicitor Type

When querying for constituents who have an Assigned Solicitor relationship that is not a specific Solicitor Type and the constituent has more than one Assigned Solicitor relationship on their Relationships tab, they do not appear in the results. When querying for constituents whose spouse does have an Assigned Solicitor relationship that is not a specific Solicitor Type, the correct constituents pull into the results.

Article
Number:95176

Products:

Raiser_s_Edge_RE

This issue has been evaluated and determined to be working as designed. In this instance the negative operator in the Query criteria would exclude any records that hold an Assigned Solicitor relationship with that specific type. An alternate approach to achieve the desired results for this specific query is to use a positive operator such as One Of and include only the desired Solicitor Types.

We recommend adding any program suggestions to our Ideas Community page. Our developers check here first when building program enhancements to see what our users are most interested in seeing implemented.

Steps to Duplicate

Create two constituent records that are linked by a Spouse relationship or select two existing constituent records that are linked by a Spouse relationship (i.e. Joseph Diresta and Angela Diresta)

On Joseph Diresta’s record, add two Assigned Solicitor relationships with two different Solicitor Types. (i.e. One Assigned Solicitor has the Solicitor Type “Former” and the other Assigned Solicitor has the Solicitor Type “Primary”)