Data types

PermeAgility tables support a number of common column data types:

• • Floating point number - For decimal numbers (25.12)

  • Whole number - For integer numbers (250)

  • Decimal - For currencies and amounts without the usual floating point problems

  • Text - For alphanumeric data (Can be any size. Size is not specified)

  • Date - For dates with no time - displayed according to locale - edited with a date control (date control is not internationalized yet)

  • Datetime - For dates and time

  • Boolean - For on/off or true/false flags - displayed as a checkbox

  • Link - For references to other tables. See Link columns

  • Link Set - For unordered lists of references to other tables (will display as a list with a pick list to add or remove entries)

  • Link List - For ordered lists of references to other tables (will display as a list with a pick list to add, reorder or remove entries)

  • Link Map - For ordered lists of named references to other tables (will display as a list with a pick list to add, reorder or remove entries)

• Image/Binary - For images and other binary files - thumbnails and popups will be used for images, others files can be downloaded

Text

Text data fields can be of any size. The database can hold text fields up to Integer.MAX_VALUE or 2,147,483,647 characters but because these are edited through the web browser, the text field can only support up to the limit of what can fit in an HTML request.

Text fields for editing are presented to the user in two ways; as a simple text field or a larger text area.  A text field will not allow multiple lines but a text area can contain multiple lines.  This is selected by the framework based on a threshold (default is 40). Once the data in a text field exceeds the threshold, the field is displayed as a text area.

The text area can be changed by adding a record for classname org.permeagility.web.Table and field TEXT_AREA_THRESHOLD to the Constant settings.

Floating Point

A floating point field uses the DOUBLE type in the database. It can hold numbers up to 1.7976931348623157e+308.

Whole Number

The whole number data type uses the BIGINT database type. It can hold numbers from  -9223372036854775808 to 9223372036854775807.

Decimal

Good for money amounts

Date and Datetime

The datetime type uses the TIMESTAMP database type. This holds data values and times down to the nanosecond. When editing date times, a popup control is used to allow the user to select a date from the calendar as shown below: (the Date type will not show the time)

Date formats for display use date formats based on the users selected locale or language. See Internationalization for details on how multiple languages can be used and configured.

Boolean

The boolean field holds true/false, on/off, or yes/no values. The default is false and the field is represented as a checkbox in the user interface. It is recommended that boolean fields be named as a positive to avoid confusion.

Image/Binary

Blob is used for binary files. 

The blob field can be changed by clicking the Choose File option to select a file to be uploaded when the form is submitted.

Small and medium size thumbnails are automatically created for images and stored in the thumbnail table.

When the picture is shown in a table or form, the small thumbnail is used.  When a user hovers over a thumbnail, a popup will display the medium thumbnail and allow the user to view or download the full size image.

Link

Need description and screenshot here or link to another page...

Link Set

Need description and screenshot here or link to another page...

Link List

Need description and screenshot here or link to another page...

Link Map

Need description and screenshot here or link to another page...