Variables
In addition to the SQL statements, the variables you can use in Web Configuration SQL are shown in the following table:
PSS1 Variables | PSS2 Variables |
---|
| = [&DATASECTION] |
_USER | = [&PERSON] |
_USERPROPERTY | = [&PERSON.PROPERTY] |
_USERSPACE | = [&PERSON.SPACE] |
_USERDEPARTMENT | = [&PERSON.DEPARTMENT] |
_USERADDRESS | = [&PERSON.ADDRESS] |
_USERCOSTCENTRE | = [&PERSON.COSTCENTER] |
The following example shows the use of variables.
GOAL: "Show the order of the logged-in user, or the orders that have been repeated (by the back Office) for that user":
PSS1 "From" clause
AND ((SYSPERS = _USER) Or
SYSORD In (Select SYSCODE From ORD Where SYSPERS = _USER)))
PSS2 "From" clause
AND ((MAIN_TABLE.SYSPERS = [&PERSON]) Or
(MAIN_TABLE.SYSORD In (Select SYSCODE From ORD Where SYSPERS = [&PERSON])))