Skip to Content

The local variable return NaN value in B1if sqlCall

Experts,

1. I create a sqlCall ATOM to a step, with below SQL script:

#SELECT DocEntry, CardCode, CardName, DocDate, DocTotal FROM $TableName WHERE DocStatus = '$DocStatus' OR '$DocStatus' = ''

2. Then I add two local variables as below picture:

3. This is Inbound - Channel

Result: This is the debug result, the values of "TableName" and "DocStatus" are blank.

Any suggestion?

Best Regards!

Robin Feng

2018.3.2

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 02 at 05:25 PM

    Hello,

    you've defined that the values of the two variables are taken from the sender/test message ($msg/...).

    It's seems your sender/test message is either not defined or you didn't handover values for the given paths.

    How does your sender/test message look like?

    Best regards

    Bastian

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Bastian,

      Thanks a lot.

      The "NaN" issue was fixed, after I use this SQL script:

      #SELECT DocEntry, CardCode, CardName, DocDate, DocTotal FROM $string(TableName)
      WHERE DocStatus = '$DocStatus'  OR '$DocStatus' = ''