i have a vie having all duplicate records.from that records i want only those records which are last updated.
please tell me how to do it
Subject: Delete duplicate document from view
you’d need a “key” in order to identify the duplicate docs. build a view to display the key in the first column.
get first doc in the view
now use you key field to get a collection of all docs with the same key getalldocumentbykey
if your collection count is greater than 1 …
then compare the last modified date for each document in the collection and keep the most recent