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

Version management

Difference between version and

At line 11 changed one line
;[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.
;[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 15 changed 2 lines
;[Type|CONDITION_TYPE]:This field indicates whether the criteria have been written in the Java or if the criteria are defined on an ‘as required’ basis. There are two options available, Java Defined and Ad Hoc. Users should use the type Ad Hoc.
;[Java Code|PREDEFINED_CONDITION_CODE]:Some 'pre-loaded' where clauses contain java logic, this predefined logic is specified in this field. This field is not used with user-defined where clauses or conditions.
;[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.
;[Predefined|PREDEFINED_CONDITION_CODE]:Some 'pre-loaded' where clauses contain predefined java logic, these predefined logic codes are specified in this field. This field is not used with user-defined where clauses.
At line 21 removed one line
;[Grouping|GROUPING]: This field is not used at this time.
At line 23 removed one line
;[Usage|CONDITION_USAGE]:This field is used to determine whether a condition on a where clause was supplied or has been added by a user to customize the where clause.
At line 23 added one line
At line 32 changed one line
;[Physical Column|COLUMN_NAME]:This field indicates the name of the column in the table as defined in the database.
;[Physical Column Name|COLUMN_NAME]:This field indicates the name of the column in the table as defined in the database.
At line 36 added 2 lines
[{If var='loginstatus' contains 'authenticated'
At line 38 changed 2 lines
![Notes|Edit:Internal.IMWC]
[{InsertPage page='Internal.IMWC' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.IMWC]
[{InsertPage page='Internal.IMWC' default='Click to create a new discussion page'}]
}]