Question
Last activity: 5 Oct 2015 4:19 EDT
Determine duplicate records in a list of records.
Hi ,
In our system, Rendering a set of list of records on the screen in which duplicates may exist,so need to find out those list of replica records by considering 4 properties among many.
and system should alert the user about the duplicate records by displaying the error message ,as need to display the "X" error message at the records which are duplicates.
Let's assume 5 records are exist , and 1 &3 are duplicate ,so error message gets displayed at 1 and 3 records when user trying submit the action.
I'm thinking, it couldn't be done by using a Validate rule, as each record has to compare against all remaining records to find out duplicates .
I would prefer to do it in post activity of action,and Error Message can be flash on top of screen by using Page-Set-Message.
How do we display the red 'x' mark at the specific rows which are duplicates.?
Please suggest me if we have a best approach to highlight the duplicate rows.
Version:7.1.6
Pegasystems Inc.
JP
How about this,
1. define a transient property, let say it "isDuplicate", which holds the duplicate check results
2. define a validation rule which checks the "isDuplicate" and sets error message if the value indicates the row is duplicated.
3. in your post flow action activity, first check and set "isDuplicate" for each row, then call the above validation rule which will set messages and red "X" on each row.
Updated: 7 Sep 2015 7:22 EDT
Thanks Chunzhi for respone.
I couldn't make to flash a red 'X' on each row of gird records which are duplicate.
i tried it using Validate Rule & Property-Set-Message but not working as it's displaying on top of harness and below of harness instead of at field levels.
Pegasystems Inc.
JP
is the property specified as validation target, on which red X should appear, displayed on the row?
the actual check logic doesn't have to include the property.
Yes ..Target property is being displayed on the row.
I'm thinking to have new column as first col.in gird layout,and drop the "X" image over there, and display it when Duplicate record found (like .IsDuplicate=='true').
Pegasystems Inc.
JP
is target property read only? red X doesn't appear with read only field.
As you said having a dedicated column for error indicator is another approach.
Pegasystems Inc.
IN
>>> having a dedicated column for error indicator is another approach...
would it be convincing/possible to filter the list using @IsInPageList(.Name,"Name", GetProductNames.pxResults) and build the final list presenting the repeat grid UI?