SQL Query

[Frank]

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 

[Piotr Bojko]

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.

[Tuncay Senturk]

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?

[Frank]

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?