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
