where can i see the Reporter field info in the issue screen from the JIRA database?

[Roberto Caballes]

I need to get the first name and last name from the database for Reporter field item in the issue screen.

[Nic Brough -Adaptavist- · Accepted solution]

Standard response:  Do not bother trying to read a JIRA database, it is a data storage system, and is not designed for any form of reporting.  SQL is absolutley the worst way to get any information out of a JIRA system, and there is a better way to do what you're trying to do.

But, if you must do it the wrong way,

• read jiraissue for the reporter field
• use what you find in there to read cwd_user

[Roberto Caballes]

great! i found it. thanks!