Tuesday, March 19, 2019

To enforce Email uniqueness across all records > search Entities that have duplicate Email address

To search for non-unique Emails across all records, users can customize an Entity Saved Search.

Steps:
1.Navigate to Reports > Saved searches > All saved searches > New.
2. Click Entity.
3. Navigate to Criteria tab > Summary sub tab > enter the below in one line:
-- Summary type = Count
-- Field = Internal ID
-- Description = greater than 1

3. Navigate to Results tab > Columns sub tab:
- Email (Summary type = Group)
- Internal ID (Summary type = Count)

Note: If users want the detailed results, users can add the following fields:
Results tab > Column sub tab:
- ID
- Name
- Number
- Type

4.Click Save&Run.

No comments:

Post a Comment