A Database definition. The storage name When database specific code is required. How to create primary keys. May be used when hand made sql is required. Used to insert functions into the sql The definition of a database table. The database name How to create primary keys. May be used when hand made sql is required. Used to insert functions into the sql identifier for this db_specific element. This identifier is set in the configuration and is used to determine which db_specific elements should be used,. identifier for this primary key creation sql used to create primary key identifier for this sql The hand made sql. Note that str replacements using the ${...} may be included in the sql. This attribute is only optional if the sql is set in the content of the sql element instead. If no sql is set an exception will be thrown when you try to access it. identifier for this function The function sql. Note that str replacements using the ${...} may be included in the sql and ${p1} is used to insert the field name. The table name - must match the database table name This is used instead of the table name when building the query field outputs.

When the system is building an SQL query the table name is placed before the field name to create a unique identifier. eg. "table.fieldname".

This is also used when building the identifier for the "as". eg. "select table.fieldname as table_fieldname from"...

If this is set then the alias value will replace the table name for the output. eg. "select table.fieldname as alias_fieldname from"...

If this is set to an empty string than the table name will not be used for the output. eg. "select table.fieldname as fieldname from"...

The name of the field, must match the table field name. Name used when displaying the primary key. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') Regerence to a primary key creator. A Java Regular Expression used to validate data beforing storing into a database. List of fields, one or more which may be included within the foreign key. These fields must match those in the referencing table, the presentation_name and length may differ. The name of the field, must match the table field name. Name used when displaying the primary key. A tooltip. Usually shown on mouse hover. The name of the table that this key references The foreign_table_alias is used TO set the alias table name in the "from" list. Example "select t.id from table as t" In the above example the table is renamed to t and its fields may be referenced using t.fieldname. The foreign_table_alias is required if you need to retrieve multiple sets of data from a table using different where clauses. The field in the reference table that this key references. Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A where is used to select the data returned from a select. In this location the where can fine tune the result of the query, applying it specifically to the foreign table. Do not provide the 'where' syntax for the where clause. Instead only provide the conditions of the where clause. example:
tb1.id=tb2.id
or
tb1.name like 'fred'
or
tb1.id=tb2.id and tb1.name like 'fred'
If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. The name of the field, must match the table field name. Name used when displaying the primary key. The display width of the field. The storage size of the field in the database Set true to allow editing of this field. Set true to mark this field as mandatory when editing. Set true to mark this field as unique. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. The name of the field, must match the table field name. Name used when displaying the primary key. The display width of the field. The storage size of the field in the database The display height of the field. If this is set true then a html edit page is displayed when editing this field. Set true to allow editing of this field. Set true to mark this field as mandatory when editing. Set true to mark this field as unique. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. The name of the field, must match the table field name. Name used when displaying the primary key. The display width of the field. The storage size of the field in the database Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. The name of the field, must match the table field name. Name used when displaying the primary key. The display width of the field. The storage size of the field in the database Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. The name of the field, must match the table field name. Name used when displaying the primary key. The display width of the field. The storage size of the field in the database The max allowed width of the image. The max allowed height of the image. Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. The name of the field, must match the table field name. Name used when displaying the primary key. The display width of the field. Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. The name of the field, must match the table field name. Name used when displaying the checkbox key. The display width of the field. Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS')

Sets the acceptable binary pattern for false/true, no/yes, N/Y, 0/1.

Note the false value must be first followed by the seperator / followed by the true value.

The first entry in the pattern is always considered the false value and the second entry in the pattern is always considered the true value.

The seperator between the false and true value is the / character.

Any leading or trailing whitespace is removed.

Example:

  • Y/N
  • true/false
  • 1/0
  • X/Y

This is an optional attribute and if not used the default pattern is true/false

The name of the field, must match the table field name. Name used when displaying the primary key. The display width of the field. Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. The name of the field, must match the table field name. Name used when displaying the primary key. The display width of the field. Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. The name of the field, must match the table field name. Name used when displaying the primary key. The display width of the field. Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql. The function StrSubstution to replace ${p1} with the table.fieldname. example to_char(${p1}, 'DD/MM/RRRR HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. The name of the field, must match the table field name. Name used when displaying the primary key. The display width of the field. Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A tooltip. Usually shown on mouse hover. If we want to call a function in the sql.
The function StrSubstution to replace ${p1} with the table.fieldname.
example to_char(${p1}, 'HH24:MI.SS') A Java Regular Expression used to validate data beforing storing into a database. Use for entries such as "Y,N" or "Y,N,U" or "Yes,No,Maybe,Perhaps" or "true,false" or "Fast Car;Slow Car;" ]]> The name of the field, must match the table field name. Name used when displaying the primary key. Set true to allow editing of this field. Set true to mark this field as mandatory when editing. A tooltip. Usually shown on mouse hover. A Java Regular Expression used to validate data beforing storing into a database. Implies an inclusion for the list of field elements for a table. The name of one of the foreign tables that are referenced from this table. The name of one of the foreign tables that are referenced from this table. Can select a single or multiple select set of radio buttons or check boxes.