How to Warn if a Duplicate Record is being created
B
Bharat Joshi
started a topic
about 1 year ago
When we need to check if the record being created is already present in the Database and send a Warning if it is the case.is it possible?
Best Answer
B
Bharat Joshi
said
about 1 year ago
When we need to check if the record being created is already present in the Database and send a Warning if it is the case.
If the entity is of type Basic or ID-Matched we can use Detect-Dups to check the duplicate records
Basic and ID-matched entities do not support fuzzy matching in the certification process. However, you still can define matchers for these entities. Such matchers are used only to detect duplicates at record creation time. When a user creates a new record, and the DETECT_DUPS validation is active, the matcher is used to search for similar records in order to warn the user when a new entry matches existing records.
To achieve this
we need to follow a two step process
1) create a “SemQLMatcher - ” named “NewRule” with a Match Condition of “Record1.TopNickname = Record2.TopNickname ”
2) Create a Stepper like “AuthorNicknames” and under Validations for Entity Name “NickName” and Validation Type “DETECT_DUPS” choose Warn or Block as you need.
When you include the detect_dups in stepper and set as warn,it will show the message as below
1 Comment
B
Bharat Joshi
said
about 1 year ago
Answer
When we need to check if the record being created is already present in the Database and send a Warning if it is the case.
If the entity is of type Basic or ID-Matched we can use Detect-Dups to check the duplicate records
Basic and ID-matched entities do not support fuzzy matching in the certification process. However, you still can define matchers for these entities. Such matchers are used only to detect duplicates at record creation time. When a user creates a new record, and the DETECT_DUPS validation is active, the matcher is used to search for similar records in order to warn the user when a new entry matches existing records.
To achieve this
we need to follow a two step process
1) create a “SemQLMatcher - ” named “NewRule” with a Match Condition of “Record1.TopNickname = Record2.TopNickname ”
2) Create a Stepper like “AuthorNicknames” and under Validations for Entity Name “NickName” and Validation Type “DETECT_DUPS” choose Warn or Block as you need.
When you include the detect_dups in stepper and set as warn,it will show the message as below
Bharat Joshi
When we need to check if the record being created is already present in the Database and send a Warning if it is the case.is it possible?
When we need to check if the record being created is already present in the Database and send a Warning if it is the case.
If the entity is of type Basic or ID-Matched we can use Detect-Dups to check the duplicate records
Basic and ID-matched entities do not support fuzzy matching in the certification process.
However, you still can define matchers for these entities. Such matchers are used only to detect duplicates at record creation time. When a user creates a new record, and the DETECT_DUPS validation is active, the matcher is used to search for similar records in order to warn the user when a new entry matches existing records.
To achieve this
we need to follow a two step process
1) create a “SemQLMatcher - ” named “NewRule” with a Match Condition of “Record1.TopNickname = Record2.TopNickname ”
2) Create a Stepper like “AuthorNicknames” and under Validations for Entity Name “NickName” and Validation Type “DETECT_DUPS” choose Warn or Block as you need.
When you include the detect_dups in stepper and set as warn,it will show the message as below
Bharat Joshi
When we need to check if the record being created is already present in the Database and send a Warning if it is the case.
If the entity is of type Basic or ID-Matched we can use Detect-Dups to check the duplicate records
Basic and ID-matched entities do not support fuzzy matching in the certification process.
However, you still can define matchers for these entities. Such matchers are used only to detect duplicates at record creation time. When a user creates a new record, and the DETECT_DUPS validation is active, the matcher is used to search for similar records in order to warn the user when a new entry matches existing records.
To achieve this
we need to follow a two step process
1) create a “SemQLMatcher - ” named “NewRule” with a Match Condition of “Record1.TopNickname = Record2.TopNickname ”
2) Create a Stepper like “AuthorNicknames” and under Validations for Entity Name “NickName” and Validation Type “DETECT_DUPS” choose Warn or Block as you need.
When you include the detect_dups in stepper and set as warn,it will show the message as below
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 276 topics