Is there a logical explanation for why the created, updated and startdate of the worklog table all have the same values for all the rows? Is it supposed to be this way or is it because it is a dummy data? Can you help me understand the differences between the three fields?
How can I find the start time and the end time of an issue for its issueid?
Also, what is the unit for the timeworked field in the worklog table?
Hello @Siddhant Bane
Each of those fields has a different purpose that is not too obvious at first, but becomes rather self explaning during usage.
The Created Date shows you the point in time when this issue was created originally and is used throughout all jira applications as it belongs to Jira Core.
The Updated Date gets modified, whenever someone changes an issue. Therefore it shows the point in time, when this issue was last edited in any way. Like the created date it is a standard that is used throughout all jira applications.
The Start Date is the point in time, when you plan to start work on your issue. It is mainly used within Portfolio for jira and by installing the app it will be added as custom field. I have never taken a look at it on a db level, but either it always holds a default value that remains hidden until modified, or it is was explicitally configured to receive a default value in your instance.
I hope that this was able to resolve some confusion. Have a happy new year and cheers,
Andrej from greenique
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event