Degraded performance Customers may experience intermittent errors using Community search. Our platform vendor is investigating.
It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
Hi,
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;");
return results;
image2017-3-23 15:20:1.png
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.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.
Read moreAs 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 groupConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
Start an AUGYou're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.