User Tools

Site Tools


Guide Section: An EASAP GUI

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:

  1. Query a database for cases that meet User-specified criteria
  2. Let a User select a single case
  3. Deliver a database-linked Excel spreadsheet…initialized with that case's data
  4. Let a User modify the case within Excel
  5. 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.

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
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
FILTERdynamically modify which case records are visible according to the value of a logical comparison.
EXTERNAL FILTERdynamically 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

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.