Alerts in input form

Avatar

Avatar

Ramusmartguy

Avatar

Ramusmartguy

Ramusmartguy

06-03-2020

Hi Team, 

 

i have an input form and an input like below : 

<check expr="nova_offer_validateActiveOfferCount_Test( @IOPERATIONID ) != '0'">
<error>"The number of active offers exceeds the number provided on the Campaing Input Form. Please deactivate an existing offer before creating a new offer."</error>
</check>

 

where "nova_offer_validateActiveOfferCount_Test" is my postgre function which i am executing in SQL script under administratrion. i want to know what value this function is returning. How can i do that. i thought of writing an alert inside the check like : 

<check expr="nova_offer_validateActiveOfferCount_Test( @IOPERATIONID ) != '0'">

alert("retrun value .."+nova_offer_validateActiveOfferCount_Test( @IOPERATIONID ));
<error>"The number of active offers exceeds the number provided on the Campaing Input Form. Please deactivate an existing offer before creating a new offer."</error>

 

but it's now happening. Any ideas how do i know the value which the sql function is returning. ?

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Milan_Vucetic

MVP

Avatar

Milan_Vucetic

MVP

Milan_Vucetic
MVP

09-03-2020

Hi @Ramusmartguy ,

 

One of the ways is to store your calculation in a field and then print the value.

Example of SMS length: <value label="Length" xpath="/tmp/sms/preview/@length"/>

 

Regards,

Milan

Answers (0)