where is system field stored in jira database?

[fabby]

my jira version is 4.4.1.

i want to get 'Time Spent' 's value. It is one of 'Log Work' 's sub Field.

i can not find any information about system field in jira database

[Renjith Pillai · Accepted solution]

Worklog entries are stored in the table . You need to join the query with jiraissue table to get the values.

The following query will give the value in seconds.

select pkey,sum(timeworked) from worklog,jiraissue where jiraissue.id=worklog.issueid group by pkey

[fabby]

thanks,Rehjith.