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..
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.