Query Question

Leslie Miller

Good afternoon,


I am trying to run a constituent query with very limited criteria:

(Organization Relation Organization Name equals XXXXXXX

AND Organization Relation Reciprocal equals Member)

Output:

Primary Addressee

Constituency Code


Results:

*When I DO NOT suppress duplicate rows my results are 347.

*When I DO suppress duplicate rows my results are 445 (I have never had MORE results by suppressing duplicate rows). Ninety-eight of these results are not correct because their reciprocal relationship is NOT Member, it is Former Member. As soon as I add Organization Relation Reciprocal to the output, the incorrect 98 go away and I'm back to results of 347.

*If I DO NOT suppress duplicate rows and output the Organization Relation Reciprocal, my results stay at 347.

*The only thing I'm changing is the output (Organization Relation Reciprocal) and suppression of duplicate rows. I'm not changing anything with the criteria.


Can anyone help me to understand this? What am I doing wrong?


Thank you!


Leslie Miller

Office of Advancement and Alumni Relations

Mercersburg Academy

717-328-6331 | o

717-328-6211 | f

Shelly Gammieri

Maybe try simplifying further... just a query with org name equals X, and then just export the members.


Best of luck!

John Heizer

This may not be your particular issue but when I am looking for a specific organization I don't use Organization Relation Organization Name, I would always use Relationships -> Organizations -> Specific Organization Record.  The name might inadvertently match multiple records.


Because you are outputting Constituency Code which can have multiple values you will inevitably see duplicates that can't be suppressed in your Query output.


Sometimes (but not always) putting two criteria that might have multiple values inside parenthesis will force RE to do paired comparisons (comparing that specific Org Relationship to that specific Relationship Relation Code).  Sometimes RE will look at ALL Relationships to find any that, in this case, equals Member, regardless of whether that specific Relationship is connected to the Org you want.  Either way, the Output will almost always include ALL possibilities that exist on that Constituent's record.  Remember the RE Mantra: Query is a grouping tool, not a reporting tool.  I think if you change this to a Static Query you'll find that the number of rows saved doesn't change regardless of the Output or duplicate suppression.


One thing you might try is under Tools -> Query Options -> Advanced Processing.  Try using the alternate SQL methods and see if that changes anything.