Wrong author name in work log result Edited

[Olfa Gharbi]

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]
,display_name
,[parent_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