Homepage | About EASA | Contact
Sidebar
CASE VIEWER
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 :
- Query a database for cases that meet User-specified criteria
- Let a User select a single case
- Deliver a database-linked Excel spreadsheet
- → Initialized with that case's data
- Let a User modify the case within Excel
- Let a User save that case back to the MySQL instance from within Excel
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:
 CASE VIEWER |
|
|---|---|
| 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. |
Formats: and Separator for Formats:
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:
- %s→string
- %S→uppercase string
- %f→ floating point number
- %f10.4→ floating point number with a minimum number of characters to be writing of 10 and precision of 4
- eg. 000654.1234 for 654.12345
- %g → scientific notation
- eg. 6e+12
- $ %s → constant string + string
- eg. $ 16.49
- %,f.2 → add locale-specific thousands separator to a floating point number
- eg. 4,321.98 for 4321.98
- %d → format result as an integer
- %(d → enclose negative integer in parenthesis
- eg. (1000) for -1000
- %+d always include a sign
- eg. +45 for 45
Mortgage Calculator EASAP with a CASE VIEWER
The Mortgage Calculator (Excel Desktop Client) EASAP uses a CASE VIEWER to search for and select a mortgage record to modify in a mortgage calculator spreadsheet.
