Homepage | About EASA | Contact
Guide Section: An EASAP GUI
EASAP Tree: USER INTERFACE → FORM LIST or TABBED PANE LIST → FORM or TABBED PANE
CASE VIEWER is a GUI object with visual and functional similarities to DATA TABLE but specialized for the search, selection, retrieval of a case, and subsequent launch of an Excel Client.
CASE VIEWER may have Child FILTER objects that create SQL queries to allow a User to search for and then select a case.
With CASE VIEWER and a Child FILTER an Author may present the following steps to a User :
Once a case is selected, the CASE VIEWER reference will contain the value of that case id for use in a DATABASE TO EXCEL DESKTOP→Case Id:
![]() |
|
---|---|
Essential Parameters: | |
Columns: | Select Excel named ranges or MySQL metadata to populate CASE VIEWER table |
Column Titles: | Comma separated strings to describe each column in a header |
Optional Parameters: | |
Title: | Title text |
Width: | Width in pixels |
Height: | Height in pixels |
Header Height: | Header height in pixels |
Table Style: | TABLE STYLE for CASE VIEWER |
Title Style: | HTML STYLE for Title: |
Show if: | Logical expression, if TRUE then box shown, if FALSE then box NOT shown |
Column Sizes: | Comma-separated literal pixel widths or object references |
Lock Column Width: | Allows dynamic modification of column width, default→FALSE |
Delimiter: | Character to delimit object references in Column Titles: or Show if: (default→%) |
Excel File Whitelist: | Whitelist of spreadsheets to allow within CASE VIEWER |
Pattern: | Display dates in this format (default→dd-MM-yy see Date Formats in an EASAP) |
Count: | Enter the name of a new SCALAR which will contain the number of results returned in the result set restricted by FILTER conditions. |
Refresh on Save: | Update this CASE VIEWER data following an EASA Ribbon→Save from within an Excel Client (default→FALSE). |
Displayed Cases: | Enter the name of a new explicit LIST which will contain case ids for the current state of the CASE VIEWER. |
Formats: | printf()-style Separator for Formats: separated formatting strings for each of the Columns: of data, although dates or times are not supported. |
Separator for Formats: | Separate the strings specified in Formats: with this character. Comma is not recommended as it is interpreted as a 'thousands separator', % (percent) is reserved as a prefix for a format specifier as well, / or <FORWARD SLASH> is the default. |
A CASE VIEWER may have either of two Child objects:
Object Name | Description |
---|---|
FILTER | Dynamically modifies which case records are visible according to the value of a logical comparison. |
EXTERNAL FILTER | Dynamically modifies the case records visible according to the case id's returned from the SQL in its External SQL: parameter. |
A lengthy javadoc reference for Java formatting may be found at:
https://docs.oracle.com/javase/7/docs/api/java/util/Formatter.html
Here we introduce a format specifier and give some examples.
Formats: contains a list of format specifiers separated by the character set in Separator for Formats:
The length of this list must be the same as the length of the list in Columns:
Below are some common format specifiers for strings and floating point data: