Skip to content

GitLab

Closed
Created by Matija Obreza@mobrezaOwner

Update statistics

Add a page /acn/updates (?) to display number of accessions updated.

Updates overview query

Get the update statistics by Year, Month, Day per Institute:

select year(lastUpdateDate), month(lastUpdateDate), day(lastUpdateDate), institute, count(*)
 group by year(lastUpdateDate), month(lastUpdateDate), day(lastUpdateDate), institute

DB index on lastModifiedDate is recommended.