User Picker (single user)

[Punchi Rao]

sql to find  custom field of User Picker (single user)

[Martins Vanags -eazyBI-]

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

[Nic Brough -Adaptavist-]

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?

[Punchi Rao]

Hi Nic

Do you mean find the field in the database --Yes 

Thanks

[Nic Brough -Adaptavist-]

Look at the table customfield

(But, please, don't.  Use the API, not the database)

[Punchi Rao]

Thanks Nic , 

any chance u have used Easy BI plug in..

[Nic Brough -Adaptavist-]

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.