Getting the list of latest updated entries: Postgres complains

[joeri.theelen@…]

In class "org.fao.geonet.guiservices.metadata.GetLatestUpdated", the SELECT query for getting the list of last updated entries in the catalogue, should not only ask for the field "id" but "changeDate" as well, as "changeDate" is in the ORDER BY clause. Postgres complains about this.

SELECT DISTINCT id, changeDate FROM Metadata, OperationAllowed
WHERE ...
ORDER BY changeDate DESC