sql to find custom field of User Picker (single user)
1. SQL is the worst possible way to report on Jira. Please, don't. Re-examine your requirements, because you've landed on a dreadful way to meet them.
2. Do you mean find the field in the database, or the value stored in the field for a particular issue?
Hi Nic
Do you mean find the field in the database --Yes
Thanks
Look at the table customfield
(But, please, don't. Use the API, not the database)
Thanks Nic ,
any chance u have used Easy BI plug in..
Yes, quite a lot, mostly to get people to stop trying to use SQL because it's the worst possible way to report on Jira. EazyBI understands Jira's data for you, and hence moves you away from SQL.
Hi Punchi,
Nic is right.
You could import custom field (user-picker) into eazyBI as a separate dimension and use this field when creating reports.
https://docs.eazybi.com/display/EAZYBIJIRA/JIRA+Issues+Import#JiraIssuesImport-JiraCustomFields
eazyBI is familiar with most types of custom fields and then there is a bunch that you could define using eazyBI advanced settings.
Note that you can have a 30 days trial period to get familiar with eazyBI.
Best regards,
Martins / eazyBI team
It looks like you're new here. Sign in or register to get started.