how to use JQL to output user properties in a column with their worklog

[Josh Kronick]

I am curious.. If i set a user property in their user profile from my site administration panel, is there a way that i can use JQL to output to a column, the value of those user properties, when i am creating a report with JQL?

for example... i want to find all issues that user X worked on in Project Y, and when the results are returned, include a column that displays a specific user property?

please advise,

Thanks

[Andy Heinzer]

With native Jira alone, no, it is not possible.  Jira's JQL is intended to only return Jira issues.   So these other fields such as a user property is not something Jira can display in the search results.

It might be possible though that this could be returned by a 3rd party plugin to Jira.   From a quick search I came across the this thread about how scriptrunner could be used to report on jira user properties:  https://community.atlassian.com/t5/Answers-Developer-Questions/Can-I-report-based-on-user-properties/qaq-p/545768

I'm not sure if this would help in regards to how Jira displays JQL results, but it might be one way to show this data.

[Josh Kronick]

i still face some challenges with this issue....

for 1) i was never able to get scriptrunner working in JIRA Cloud the way i wanted it to.

and 2) i forgot to mention that we already use a jira add-on for time-tracking (Tempo Timesheets) and that is part of the hurdle. 

i appreciate your feedback, but that did not resolve the issue.

thanks again,

Josh Kronick