Question8Replies5616Views BrahmeswaraRao Member since 2016 37 posts Posted: 5 years agoLast activity: 5 years ago Closed Solved 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 User Interface ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 5 years agoChunzhi_Hong PEGA replied to BrahmeswaraRaoHow about this,1. define a transient property, let say it "isDuplicate", which holds the duplicate check results2. 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. Posted: 5 years agoUpdated: 5 years agoBrahmeswaraRao replied to BrahmeswaraRaoThanks 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. Posted: 5 years agoChunzhi_Hong PEGA replied to BrahmeswaraRaois 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. Posted: 5 years agoBrahmeswaraRao replied to Chunzhi_HongYes ..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'). Posted: 5 years agoChunzhi_Hong PEGA replied to BrahmeswaraRaois 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. Posted: 5 years agosahup1 PEGA replied to Chunzhi_Hong>>> 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? Posted: 5 years agoBrahmeswaraRao replied to Chunzhi_HongYes.. mode of fields are read only. Posted: 5 years agoBrahmeswaraRao replied to BrahmeswaraRaoWe’ve accomplished it by having a dedicated column to display the red "X" indicator for the duplicate rows. Thanks for your contribution .