I would like to get list of customfields in JIRA?? I know how to get using API. I would like to get it rows and columns
All custom fields are stored in customfields table in Jira.
Also you can find options and values in customfieldoption and customfieldvalue tables.
Is that what you were asking for?
Yes, I am looking for sql query.
Something simple to get you started? :
select * from customfield limit 10;select * from customfieldoption limit 10;select * from customfieldvalue limit 10;
How are you intending to query?
With this addon - https://marketplace.atlassian.com/apps/1218767/smart-ql?hosting=server&tab=overview - you can query JIRA with SQL straight from the app or through the special JDBC without to worry about permissions to data.
It looks like you're new here. Sign in or register to get started.
