How to extract the Assignee from Jira using a script

[CostaM]

Hi is there anyone that can assist in helping correct the code on this script to enable me to extract the actual assignee name, when using the below, it returns some kind of key rather than the actual name:

select concat (p.pkey, '-', j.issuenum) AS IssueKey,
j.summary,
t.pname as issuetype,
s.pname as status,
u.lower_user_name as assignee,
concat(u.first_name,' ',u.last_name) as "assignee full_name"
from jiraissue j
left join project p on j.project = p.id
left join issuestatus s on s.id = j.issuestatus
left join issuetype t on j.issuetype = t.id
left join app_user a ON j.assignee=a.user_key
left join cwd_user u on u.id=a.id;

thank you

[Antoine Berry]

Hi @CostaM ,

Your query should properly display the assignee full name.

You could also try

u.display_name

if you want the name as it is actually displayed in Jira.

[CostaM]

Thank you Antoine.