Tempo Accounts : Could you please help me in retri the attached results from database query

[CVeerababu]

Hi,

How do i find the link between tempo account AO table with Jira issue table .

How do i get Account information like ( Account key, Account name, Account lead, Account category, Account customer) from jira issue table.

Thanks,

Veera

[Susanne Götz _Tempo_]

Hi @CVeerababu

Information about the Tempo Account set on an issue is not stored in the jira issue table. 

To find information about the Account set on the issue, you will need first to find the id for the Account custom field in the JIRA "customfield" table 

(select * from customfield where cfname = 'Account')

With the id of the Account customfield and the id for the issue, you can then get the account id of the Account set on the issue (value in the "numbervalue" column of the customfieldvalue table)

(select * from customfieldvalue where customfield = YOUR_ACCOUNT_CUSTOM_FIELD_ID and issue =  YOUR_ISSUE_ID )


Once you know the id of the Account set on the issue, you can get information for the Account from the AO_C3C6E8_ACCOUNT_V1 table. 
This table shows the  Account key, Account name, Account lead of the Account. It also lists the Category and Customer id. 
More information about the Category and the Customer can then be found in the AO_C3C6E8_CATEGORY_V1 and the AO_C3C6E8_CUSTOMER_V1 table. 

Best regards,
Susanne Götz
Tempo team