The Suppress Duplicate Rows option does not suppress identical rows

When removing a field with one-to-many relationships from the Output tab of a query and selecting Tools>Query Options>Record Processing>Suppress Duplicate Rows, duplicate identical rows are not removed from the query results. This occurred after upgrading from 7.91 to 7.92.5508.15, as well as for all queries that include criteria with one-to-many relationships on constituent records.
We are currently evaluating this issue and will update this article when we have more information.

Alternative solution:
 
  1. Remove the address processing fields from the query Output
  2. Create an Export based on the query to pull the desired fields

Environment

 7.92.5508, patch 15 ; 7.93.5782, patch 11

Was this article helpful?