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

Roberto Caballes April 25, 2017

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

1 answer

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 25, 2017

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 April 25, 2017

great! i found it. thanks!

Suggest an answer

Log in or Sign up to answer