I have a use case where a monthly report is sent to some users that searches our repository for documents with certain criteria, namely expiration date, contract number etc. The search returns all the entries with an expiration date within a certain range. This works, however I have been asked to see if there is a way to omit duplicate entries based on a field value, namely contract number. This way, the resulting report will only have one line item per contract number.
Tried the following:
Creating a token to list all the contract numbers, retrieving the field values of the current entry, having a conditional decision to see if the combined list contains the contract number of the current entry, if not, it will append it to the list token (indexed with commas) then create a shortcut + URL + append to the report token that was created earlier which is used for the final report. I ran this, and I see the list token I made, plus the report at the end contained the duplicates still. Is there another approach I can try?