Sidebar
Table of Contents
CASE VIEWER
Guide Section: An EASAP GUI
EASAP Tree:
USER INTERFACE > FORM LIST or TABBED PANE LIST > FORM or TABBED PANE
OUTPUT > REPORT
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 database from within Excel
A CASE VIEWER reference will update with a selected case id for use in a DATABASE TO EXCEL DESKTOP > Case Id:
Use READ CASE DATA to pull data from a column of a CASE VIEWER into a LIST.
 CASE VIEWER |
|
|---|---|
| Essential Parameters: | |
| Columns: | 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 Orientation: | Enter a sequence of LEFT, CENTER or RIGHT settings for how data should be justified within each column LEFT is the default for any columns not set |
| Column Sizes: | Comma-separated literal pixel widths or SCALAR references |
| Lock Column Width: | Prevent dynamic modification of column width? default→FALSE |
| Delimiter: | Character to delimit LIST or SCALAR 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 a name for a new SCALAR which will contain the number of results returned in the result set restricted by FILTER conditions |
| Refresh on Save: | Update the CASE VIEWER table following an EASA Ribbon > Save from within an Excel Client (default→FALSE) Requires USER INTERFACE > Results Time: 1 or another low number of seconds to update the browser interface |
| Displayed Cases: | Enter a name for a new LIST which will contain case id's 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 % or <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 modify which case records are visible according to the value of a logical comparison. |
| EXTERNAL FILTER | dynamically modify which case records are 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
- %10.4f - 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 )
- %,.2f - 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.
