I am looking for a way to join the Jira Issue and related Tempo account using a SQL query.
I found this snippet:
select ps.propertyvalue from propertyentry pe, propertystring ps, worklog w, jiraissue ji where ji.pkey = 'TMA-3014' and ji.id = w.issueid and w.id = pe.entity_id and pe.entity_name = 'Tempo.Worklog' and pe.property_key = 'Tempo.WorklogAttributes' and pe.id = ps.id
But I don't find these values in the propertyentry table
We are currently on v6.0.6#6105
Can you explain what exactly you want to get out of this join.
Are you looking for Account details?
Are you using Account as a worklog attribute in Tempo or do you set the Account on Issue level ?
Kristín
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.