SQL One Value / SQL Basic Table Report Fields
To use the SQL special fields in reporting follow the below syntax:
If the SQL One Value is within a Repeat Block you must include the Special Field "Session ID" within the Repeat block that the SQL One Value is in. To use the "Session ID" variable in the SQL Query use "__SessionID__" (which is substituted out on run).
e.g (select): SELECT CallStatus from CallerList where CallRefNo = __SessionID__
e.g (stored procedure): EXEC RunReportsCaseHistory __SessionID__
Article ID: 41, Created: November 20, 2015 at 2:30 PM, Modified: February 12, 2016 at 5:09 PM