Using SCv6 6.00.018
I have a grid with the following SQL.
The SELECT
OBJ_GUID, PST_STS, MIN_LFT, PAY_MTHD, IS_ADLT, PLUS_PNTS, HAVE, NEED, NAME, CONTACT_INFO, PST_SEQ
FROM
PRC_SCANNER( ‘[usr_obj_guid]’, 0)
ORDER BY MIN_LFT DESC
The global variable, which works in all other places in SCv6, is not interpreted as a global variable in this case. Instead, it is left as a literal and characters are both prepended and appended to it… so in the php file, I end up with the non-functional SQL statement:
The SELECT
OBJ_GUID, PST_STS, MIN_LFT, PAY_MTHD, IS_ADLT, PLUS_PNTS, HAVE, NEED, NAME, CONTACT_INFO, PST_SEQ
FROM
PRC_SCANNER( ‘" . $_SESSION[‘usr_obj_guid’] . "’, 0)
ORDER BY MIN_LFT DESC
What is the syntax for preventing the character replacement, and inserting the actual guid (Like ‘7787-9909-0090’)? Or, is this a bug?