Available Languages: reporting, Maintain
The GETUSER function retrieves the ID of the connected user.
Alphanumeric, at least A8
Is the result field, whose length depends on the platform on which the function is issued. Provide a length as long as required for your platform; otherwise the output will be truncated.
GETUSER retrieves the user ID of the person running the request:
DEFINE FILE EMPLOYEE USERID/A8 WITH EMP_ID = GETUSER(USERID); END
TABLE FILE EMPLOYEE SUM CURR_SAL AS 'TOTAL SALARIES' BY DEPARTMENT HEADING "SALARY REPORT RUN FROM USERID: <USERID" " " END
The output is:
SALARY REPORT RUN FROM USERID: doccar
DEPARTMENT ---------- MIS PRODUCTION
TOTAL SALARIES -------------- $108,002.00 $114,282.00