We are using below script and running it in the sil runner gadget. But we are not getting any result.
string  results = sql("jdbc/JiraDS", "select id from customfield;");
We need to get all the custom fields from the JIRA table.
Reading the database is generally the wrong way to do things in JIRA, but...
The empty result could be a genuine case of "no custom fields defined yet" - won't be true if you have Software or Service Desk, but if it's a plain Core install, it could be. What does the GUI say is there?
If there are fields in there, then it's the connection - it's either not running the query at all, or it's unable to connect. You'll need to check the login parameters etc.
As a Jira power user, I was at first doubtful that Trello could benefit my workflow. Jira already uses boards (ones you can customize!), so why would I even need to use Trello?! In this post you will...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG