nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Do Customfields share IDs with other properties?

Sadaf Chowdhury

Given how the only way to check when a custom field was created is in the audit log, I tried to get that date from the JiraDB but unfortunately the dates did not line up properly. I was wondering if Customfields could possibly share IDs with Issues or Projects.

Accepted answers

Hernan Montes_6rmjzn

Hello Sadaf,

I'm not sure how you're querying for that information in the database, from testing I have done I can get the exact dates from the database that is shown in the audit log, please try the following queries for the results:

SELECT * FROM audit_log WHERE summary = 'Custom field created' and author_key = '<username>' ;

This will give you all custom fields created by the user

SELECT * FROM audit_log WHERE summary = 'Custom field created' and CAST(created AS DATE) = '2018-07-19';

This will give you all custom fields created on the specified date

Please follow the existing columns of the table to get the information you need.

Hope this helps!

All comments

Hernan Montes_6rmjzn

Hello Sadaf,

SELECT * FROM audit_log WHERE summary = 'Custom field created' and author_key = '<username>' ;

This will give you all custom fields created by the user

SELECT * FROM audit_log WHERE summary = 'Custom field created' and CAST(created AS DATE) = '2018-07-19';

This will give you all custom fields created on the specified date