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

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

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
24 26-Nov-2021 10:22 7 KB lurtan to previous
23 26-Nov-2021 10:22 7 KB lurtan to previous | to last
22 26-Nov-2021 10:22 7 KB rforbes to previous | to last
21 26-Nov-2021 10:22 7 KB kparrott to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 20 changed 4 lines
!Easy Add WhereClause Condition Values
;[Entity|ENTITY_CODE]:
;[Position|POSITION_CODE]:
;[Unit|UNIT_CODE]:
!Easy Add Where Clause Condition Values
The selections from the fields below will be used to create conditions in the Where Clause which will be automatically created.
;[Entity|ENTITY_CODE]: This field indicates the entity in which the list of employees will be filtered to.
;[Position|POSITION_CODE]: If the list is to be filtered to a specific position, the position code should be indicated here.
;[Unit|UNIT_CODE]: If the list is to be filtered to a specific unit, the unit code should be indicated here.
At line 37 added 14 lines
!Where Clause Conditions:
* Conditions are either added to or removed from the Where Clause specified on the People List. The result is to either further refine or lessen the restriction by the Where Clause.
* When a single value is selected, an “Equals” condition is created.
* When multiple values are selected an “In” condition is created.
* If the criteria selections are added to or removed from switching to either a single or multiple the condition will change to reflect the most appropriate type.
* If the criteria selections are removed completely the corresponding condition will also be removed.
* All other condition operators must be handled through using the where clause dialog.
* The Where Clause is created as User Defined with Ad Hoc type.
If a user wishes to have their list based on the latest assignment information then they need to manually add the two conditions seen below:
||Type||Predefined||Column||Operator||Value
|Ad Hoc| |[EFFECTIVE]| Less Than| <<AS_OF_DATE>>
|Ad Hoc| |[EXPIRY]| Greater Than| <<AS_OF_DATE>>