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])))