I have a table that has duplicate records on purpose. Students may submit an app more than once. The processors want to visually inspect those duplicates and choose which one to process or contact the student about the duplicate.
So I'd like to highlight the duplicates based on the student ssn and aid year and flag them with a highlight. That way, they'll stand out as records to research no mater how the processors sort the grid. They'll know there's another potential duplicate in the list and they can sort to find it and decide which one to keep
While I know how to write a basic sql query to show the records that have a count of a field greater than 1, how do I do this in apex,? ... show the counts for a given student ssn and aid year and/or also highlight those same rows.
Thx!