This page (revision-6) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
6 26-Nov-2021 10:22 2 KB RForbes to previous
5 26-Nov-2021 10:22 2 KB RForbes to previous | to last
4 26-Nov-2021 10:22 1 KB RForbes to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links
$L_VARIABLE
$L_VARIABLE

Version management

Difference between version and

At line 3 changed one line
Lists are used in order to simplify the number of [UserCalc] lines it would take to eliminate employees from the selection.
Lists are used in order to simplify the number of UserCalc lines it would take to eliminate employees from the selection.
At line 7 changed one line
For example: You may need to check if an employee is in any of three different groups, which normally would necessitate three UserCalc lines to check one group after the other. With the list, however, the user may define the accepted values – such as membership in any of the three different groups.
For example:
You may need to check if an employee is in any of three different groups, which normally would necessitate three UserCalc lines to check one group after the other. With the list, however, the user may define the accepted values – such as membership in any of the three different groups.
At line 12 changed 2 lines
|IN |In List
|NN |Not In List
IN - In List
NN - Not In List
At line 15 removed 3 lines
%%warning __Important Note:__\\
The $L list will works with alphanumeric values, and treats the list as character type values, even if the only values are numeric. Your tests for list inclusion or exclusion (using IN and NN) must use a character type field in Operand 1. A numeric field in Operand 1 will result in an Oracle error.%%
At line 20 changed 3 lines
||Line||CMD||OT||Operand 1||OPER||OT||Operand2||OT||Operand3||If Goto|| Else GoTo
|00010| IF|DB|DGR.GROUP_CODE|IN|$L|GROUP LIST| | |00020|99999
|00020|IF|DB|PPR.PAYROLL_CODE|NN|$L|PAYROLL LIST| | |00100|01000
Line CMD OT Operand 1 OPER OT Operand2 OT Operand3 If Goto Else GoTo
00010 IF DB DGR.GROUP_CODE IN $L GROUP LIST 00020 99999
00020 IF DB PPR.PAYROLL_CODE NN $L PAYROLL LIST 00100 01000
At line 24 changed one line
Lists are created and maintained as lexicon values in the Maintain Lexicon ([IMLN]) form. (The name of the list is the lexicon name and the list is maintained as the values within that lexicon.)
Lists are created and maintained as lexicon values in the Maintain Lexicon (IMLN) form. (The name of the list is the lexicon name and the list is maintained as the values within that lexicon.)
At line 26 changed 2 lines
!Maintain Lexicons
A lexicon provides a controlled set of values, which a particular field may contain.
Maintain Lexicons
A Lexicon provides a controlled set of values, which a particular field may contain.
You may access this feature through the Screens/Forms menu:
Application Administration > Sight Configuration > Maintain Lexicons
At line 33 changed 4 lines
The __Displayed Value__ must be the code to be looked at by the UserCalc
----
![Notes|Edit:Internal.$L_VARIABLE]
[{InsertPage page='Internal.$L_VARIABLE' default='Click to create a new notes page'}]
The Saved Value must be the code to be looked at by the UserCalc
This page (revision-6) was last changed on 26-Nov-2021 10:22 by RForbesTop