Get Result "TRUE" from JDBC query

[aleber...@gmail.com]

Dear,

I need to take an action when result of JDBC query function is TRUE

FN_VALIDATE_CONTRACT(CUIT,contract_id,rfq_date)

The JS inserted in which I generated is

<#if P_result.SECStatus?number == 200&& P_result.DBData.data[0].FN_VALIDATE_CONTRACT(CUIT,contract_id,rfq_date)?string == "TRUE">
true
<#else>
false
</#if>

But it is not working.
Can you please help me on this script?

Thanks
Alejandro

[Pankaj Kumar]

Hi Alejandro,

Kindly share the error details you are receiving and if possible please share the "P_result" variable value to us also in order to validate the script.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/5300d396-4496-47a4-9056-f3cd39cf8e74%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[aleber...@gmail.com]

Hi, the error was fixed. There was not in the jscript
Thanks
Alejandro