This page (revision-15) was last changed on 26-Nov-2021 10:22 by Kevin Higgs

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
15 26-Nov-2021 10:22 3 KB Kevin Higgs to previous
14 26-Nov-2021 10:22 3 KB jmyers to previous | to last
13 26-Nov-2021 10:22 3 KB JAiken to previous | to last
12 26-Nov-2021 10:22 3 KB RForbes to previous | to last
11 26-Nov-2021 10:22 3 KB JEscott to previous | to last FORMATTED EQUALS WHERE CLAUSE OPERATOR ==> FORMATTED EQUALS WC OPERATOR
10 26-Nov-2021 10:22 3 KB JEscott to previous | to last
9 26-Nov-2021 10:22 3 KB JEscott to previous | to last
8 26-Nov-2021 10:22 2 KB JMyers to previous | to last
7 26-Nov-2021 10:22 2 KB JAiken to previous | to last
6 26-Nov-2021 10:22 2 KB JMyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 2 KB JEscott to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 2 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links
IMWC
IMWC

Version management

Difference between version and

At line 5 changed one line
The Maintain Where Clauses (IMWC) form allows you to create and edit Where Clauses within the system. It is used to filter data on forms, approval processes, LOV’s and people lists.
The Maintain Where Clauses (IMWC) form allows you to create and edit Where Clauses within the system. Where clauses are used to conditionally select data from a table. They may be used to filter data on forms, approval processes, LOV’s and people lists.
At line 11 changed 2 lines
;[Data Source|DATA_SOURCE_NAME]:This field indicates the data source that the Where Clause will be attached.
;:e.g. The Positions table used for an LOV that the Where Clause will then filter.
;[Data Source|DATA_SOURCE_NAME]:The data source is the table location in which the information being filtered into the where statement is derived from. The data source is a mandatory 10-character alphanumeric field that the user must either manually enter or use the LOV to choose their option.
At line 14 changed 3 lines
;[Usage|WHERE_CLAUSE_USAGE]:This field will indicate if the Where Clause is Pre-loaded (system provided), User Defined or Obsolete.
;[Description|DESCRIPTION]:This field provides a short description of the Where Clause.
;[Type|CONDITION_TYPE]:This field categorizes the Where Clause into a specific type.
;[Usage|WHERE_CLAUSE_USAGE]:This field will indicate if the Where Clause is Pre-loaded (system provided), User Defined or Obsolete. All Where Clauses created by clients should have a usage of ‘User Defined’.
;[Description|DESCRIPTION]:This field provides a brief description outlining the intention of the ‘Where Clause’. Although it is not a mandatory field, it is recommended to always provide a brief description for the purpose of clarity
;[Type|CONDITION_TYPE]:This field indicates whether the criteria have been predefined or if the criteria are defined on an ‘as required’ basis. There are two options available, Predefined and Ad Hoc. Users should use the type Ad Hoc.
At line 22 changed 2 lines
;[Value|VALUE]:This field completes the SQL statement of the previous field.
;:e.g. active status, Finance department.
;[Value|VALUE]:This field indicates what data the column name is to be compared with. For example this could be the as of date, lexicon values, numbers or specific data within the database such as a department code.
At line 23 added one line
This page (revision-15) was last changed on 26-Nov-2021 10:22 by Kevin HiggsTop