Need to extract worklog with tempo custom filed data from database

[Parag Gupta]

Hi,

I need to extract jira worklog information alongwith additional fileds that I've created for tempo worklog page. Earlier i use to extract data using following query but this query stops returning data after recent upgrade.

• JIRA version from 7.0.0 to 7.12.0
• Tempo version--7.16 to 9.0 

select w.id WorkLogID, ji.id BK_IssueID, u1.lower_email_address TimeLoggedBy, i.pname IssueType, cast(w.startdate as date) TimeLoggedForDate,
w.timeworked TimeLoggedInSec, ps.propertyvalue PropertyValue, w.updated UpdatedTime
from jiraissue ji
inner join project p on p.id = ji.project
inner join worklog w on ji.id = w.issueid
inner join cwd_user u1 on u1.user_name = w.author
inner join propertyentry pe on w.id = pe.entity_id
inner join propertystring ps on pe.id = ps.id
inner join issuetype i on ji.issuetype = i.id
inner join issuestatus ist on ji.issuestatus = ist.id
inner join priority pr on ji.priority = pr.id
where
w.startdate > '2018-12-01' and w.startdate < '2018-12-31' and
pe.entity_name = 'Tempo.Worklog' and
pe.property_key = 'Tempo.WorklogAttributes'

On digging in further I found out mapping is not being saved anymore after upgrade in PropertyEntry table, and unable to extract relevant data from propertystring table.propertyvalue field. Can you please help where exactly it has been saving this now.

Regards,

Parag