Jira Issue and Tempo Account

Clive Naicker June 3, 2014

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

  • pe.entity_name = 'Tempo.Worklog'
  • pe.property_key = 'Tempo.WorklogAttributes'

We are currently on v6.0.6#6105

1 answer

0 votes
Kristin Hreinsdottir [Tempo] June 5, 2014

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events