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

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 jmyers to previous
5 26-Nov-2021 10:22 2 KB jmyers to previous | to last
4 26-Nov-2021 10:22 2 KB jmyers to previous | to last
3 26-Nov-2021 10:22 2 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
FILTER CAPABILITY IN GRID STYLE SCREENS
FILTER CAPABILITY IN GRID STYLE SCREENS

Version management

Difference between version and

At line 14 changed one line
*Filter for Open BOE (Filter list to show only open open enrollments)
*Filter for Open BOE (Filter list to show only open open enrollments)\\ \\
At line 18 changed 2 lines
!!Build Filter Where Clause:
The where clause must be created for the table which contains the data the filter will be filtering.
!!Build Filter Where Clause
The Where Clause must be created for the table which contains the data the filter will be filtering.
At line 21 changed one line
The Description field is used to display the text in the Filter By list in the form so be sure to keep these short and to the point.
The Description field is used to display the text in the Filter By list in the form, so the descriptions should be short and to the point.
At line 23 changed one line
The example screen prints below show the 3 different user defined where clauses built to create the Filter By options shown in the IBOE screen print.
The example screenshots below show the three different user-defined Where Clauses built to create the Filter By options shown in the [IBOE] screen print.
At line 25 changed one line
In IMDAO create where clause for table P2K_BE_OPEN_ENROLLMENTS.
In [IMDAO], create a Where Clause for table [P2K_BE_OPEN_ENROLLMENTS].
At line 27 changed 3 lines
This screen print shows the definition of the filter to show Open Enrollment Periods that are OPEN, this does not filter based on type of open enrollment.
[FILTER CAPABILITY IN GRID STYLE SCREENS_02.JPG]
This screenshot shows the definition of the filter to show open enrollment periods that have a status of 'Open', this does not filter based on type of open enrollment.\\ \\[FILTER CAPABILITY IN GRID STYLE SCREENS_02.JPG]\\ \\
At line 31 changed 3 lines
This example is a filter to show open enrollment periods that have a status of Open and that have an Open Enrollment Type of ‘Mass Open Enrollment’.
[FILTER CAPABILITY IN GRID STYLE SCREENS_03.JPG]
This is an example of a filter that shows open enrollment periods that have a status of 'Open' and that have an Open Enrollment Type of ‘Mass Open Enrollment’.\\ \\[FILTER CAPABILITY IN GRID STYLE SCREENS_03.JPG]\\ \\
At line 35 changed 3 lines
This example is similar to the one above however this filter will show open enrollment periods that have a type of ‘Life/Work Event’ and that have an Open status.
[FILTER CAPABILITY IN GRID STYLE SCREENS_04.JPG]
This example is similar to the one above however this filter will show open enrollment periods that have a type of ‘Life/Work Event’ and that have an Open status. \\ \\[FILTER CAPABILITY IN GRID STYLE SCREENS_04.JPG]
At line 39 changed one line
!!Add Where Clause to Form Definition:
!!Add Where Clause to Form Definition
The filter Where Clauses must be attached to the form definition of the screen they will be used in, this is done in [IMFD].
At line 41 changed 5 lines
The filter where clauses must attached to the form definition of the screen they will be used in, this is done in IMFD.
Using the IBOE example above, the screen prints below show the 3 filter by where clauses attached to the form definition for IBOE.
[FILTER CAPABILITY IN GRID STYLE SCREENS_05.JPG]\\ \\[FILTER CAPABILITY IN GRID STYLE SCREENS_06.JPG]\\ \\[FILTER CAPABILITY IN GRID STYLE SCREENS_07.JPG]
Using the [IBOE] example above, the screenshots below show the three filters by Where Clauses attached to the form definition for [IBOE].\\ \\[FILTER CAPABILITY IN GRID STYLE SCREENS_05.JPG]\\ \\[FILTER CAPABILITY IN GRID STYLE SCREENS_06.JPG]\\ \\[FILTER CAPABILITY IN GRID STYLE SCREENS_07.JPG]
This page (revision-6) was last changed on 26-Nov-2021 10:22 by jmyersTop