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.

[Christophe Chenavier · Accepted solution]

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.

[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.