Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Wrong author name in work log result


Hi Support,

We tried to get work log from Jira API. However, we found that certain work log throw wrong author name as the it's username


Here it is the sql query used :

SELECT distinct [child_name]
FROM [DB_JIRAIT].[dbo].[cwd_membership] lien
inner join [DB_JIRAIT].[dbo].[cwd_group] groupe_jira on lien.parent_id = groupe_jira.ID
inner join [DB_JIRAIT].[dbo].[cwd_user] user_jira on lien.child_name = user_jira.user_name
where group_name in ('X','Y','Z')
order by [child_name]

And as a result we get this strang author names:



Thanks in advance for all your support

0 answers

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

Apps for Confluence you won't want to miss: RSVP for September's Appy Hours

Calling all collaborators and Confluence users! Our Appy Hours event on September 29th features 4 presenters demoing functionality to superpower Confluence. Don't miss learning about these apps i...

118 views 0 9
Read article

Atlassian Community Events