Log to trace deposit date of a dataset (Dataverse v5.10.1)

[Data CUHK]

Hi everyone,

We notice that the metadata of datasets is editable and thus doesn't may not show the exact/original deposit date for the dataset.

Is there any log we can check or settings we can configure to see the original deposit date (yyyy/mm/dd)?

Thanks,

Jack

[Julian Gautier]

Hi Jack,

The exact/original deposit date for the dataset you'd like to see is when the user created the first version of the dataset, right?

If so, you could use the Dataverse API to see what's the createTime of the first version of a dataset. For the dataset at https://doi.org/10.48668/57WB4O, the API call would be https://researchdata.cuhk.edu.hk/api/datasets/:persistentId/versions/1.0?persistentId=doi:10.48668/57WB4O

But that won't work when the first version has been deaccessioned.

You can also check the datasetversion table of the repository's database to get the createtime of the first version of each dataset. That should show when the dataset's first version was created even if someone deaccessioned it.

Here's a database query I'd try. I added the dvobject table to show the identifier of each dataset, and added the dataset table so that I could exclude harvested datasets.

select
dvobject.identifier,
datasetversion.createtime
from datasetversion
join dataset on dataset.id = datasetversion.dataset_id
join dvobject on dvobject.id = datasetversion.dataset_id
where
dataset.harvestingclient_id is null and
datasetversion.versionnumber = 1 and
datasetversion.minorversionnumber = 0

It looks like the CUHK Research Data Repository hasn't harvested datasets, so maybe you could not use the dataset table,:

select
dvobject.identifier,
datasetversion.createtime
from datasetversion
join dvobject on dvobject.id = datasetversion.dataset_id
where
datasetversion.versionnumber = 1 and
datasetversion.minorversionnumber = 0