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