Is there a way to get a custom field's last updated as well as the creation date in jiradb? The customfieldvalue table gives the key "UPDATED: but unfortunately I got nothing.
Any ideas?
You need to join changeitem to changegroup to jiraissue, reading jiraissue for the issue details, changegroup for date of updates and changeitem to find the change of field data.
Thanks Nic,
Is there a way to check when a custom field was created/updated in the application/UI site? Or is it only available in the audit log?
Thank you!
The custom field header is only tracked in the audit log.
So I wrote PSQL code to get the information for all of this but my dates do not align with what I get in the audit log. They are a couple of days off..is this normal or does the date align more with when the issue was created not when the actual custom field was made?
psql \ -d jiradb \ -c "\\copy ( SELECT cf.customfieldtypekey, cf.ID, cf.cfname, ji.CREATED, ji.UPDATED FROM customfield cf JOIN changeitem ci ON cf.id=ci.id JOIN changegroup cg ON cg.id=cf.id JOIN jiraissue ji ON cg.id=ji.id WHERE cf.id=ji.id TO custom_fields.csv WITH CSV" \
It looks like you're new here. Sign in or register to get started.
