Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

SIL Script - How to get the error message from an SQL query ?

  string [] results = sql("Jira","SELECT [Name] FROM [V_Institution]);
   runnerLog("SQL query completed");
catch string err
   runnerLog("SQL query failed : " + err);
catch {
   runnerLog("SQL query failed.");

Hi all,

The catch all clause will catch the exception when the sql query failed.
How can the script get the query error message to show it immediately to the user ?

Thanks in advance for your help.

2 answers

1 accepted

0 votes
Answer accepted

So, here is the answer of the developer Radu Dumitriu : (It's not possible yet)

Anyway, I kept it in mind, and I wrote it on the ticket that lists the language improvements.

Hi @Christophe Chenavier

Not sure what Jira app you are using to implement this SIL Script. I'm going to assume that you are using Power Scripts | Jira Workflow Automation. If yes, then you can use:

lfShowFieldMessage(field, message, messageClass) 

For more information, you may refer to lfShowFieldMessage

I hope that this helps.


Hi Moga,


Yes I use PowerScript.

And yes I know lfShowFieldMessage.

But the problem here is not to display the message, but to get it.


Thanks for your answer.

From their documentation; Error handling - it looks like they are trying to keep it as user-friendly as possible by returning empty values rather than throwing exceptions where possible.

From what I can understand, if we use catch-all error, then we might not able to access the error. To confirm this, you might want to contact their support.

I have no answer from the support so far.

I will post it when received.

Like mogavenasan likes this

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you