Bookshelf Home | Contents | Index | PDF |
Siebel Developer's Reference > Business Component User Properties > Controlling Search and Sort > Removing Duplicate Records From QueriesThe Duplicate Elimination user property removes duplicate records from the result set of a query on a business component that runs in ForwardOnly mode. This result set might include multiple copies of the same record if one of the following situations exists:
You can use the Duplicate Elimination user property to determine how Siebel CRM handles these multiple copies. The value for this user property must contain a Boolean value. If:
This user property determines how Siebel CRM does aggregation. You must first make multiple settings in Siebel Tools to enable aggregation on a list column or for a multivalue link. You can configure Siebel CRM to modify the value for this user property, create a new instance of it, or deactivate it. No more than one instance can exist for each business component.
Using Duplicate Elimination with a Denormalized RelationshipA situation might exist where Siebel CRM might denormalize the relationship and view that it uses for associations that exist in the context of the parent record. It might repeat the same parent row in the result set as an association to different child records that reside in the intersection table even if no duplicate associations exist. In this situation, it might be preferable to configure Siebel CRM to not reject duplicates. |
Siebel Developer's Reference | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |