nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Christophe Chenavier

try
{
  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.

Accepted answers

Christophe Chenavier

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.

All comments

mogavenasan

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.

Thanks,
Moga

Christophe Chenavier

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.

mogavenasan

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.

Christophe Chenavier

I have no answer from the support so far.

I will post it when received.

Christophe Chenavier

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-server

jira-software-server

script