Multi-Record and Single-Record Layout Areas

Previous Next

See Also

In all pages, column values are by default displayed in either multi-record layout or single-record layout. The default column display arrangement differs between key column areas and non-key columns areas.

Key column areas

Non-key column areas

Info Page: Search area.

Info Page: Multi-record result grid.

Lookup Page: Search area.

Lookup Page: Multi-record result grid.

Related Page: Single-record area (for parent data).

Related Page: Multi-record result grid (for child data).

Info Page: Single-record result block.

Lookup Page: Single-record result block.

Related Page: Single-record block (for child data).

 

· In key column areas, the default column display arrangement is that only key columns (columns where Key = 1, 2, ...) are displayed.

 

· In non-key column areas, the default column display arrangement is that only non-key columns (columns where Key = No) are displayed.

These default rules only apply to tables where ALL columns have the In Display Selection set to NULL (the default). In other words, developers can override the default rules in USoft Definer by setting the "In Display Selection" (former "In Lookup") column attribute.

The "In Display Selection" attribute allows developers to influence the default rules declaratively from USoft Definer.

For each table, the default arrangement is changed if at least one of the columns within the table, or within a supertype table of the table, has a (numerical) value for "In Display Selection" (the default being NULL). In this case, new default rules apply:

· Columns that have a value for "In Display Selection" are shown by default in all key column areas, in the order indicated by the (numerical) values of "In Display Selection".

 

· Columns that do NOT have a value for "In Display Selection" are shown by default in the non-key column areas, in the order indicated by their Position attribute.

Some consequences of the default rules are:

· In result areas, by default, if a column is not displayed in the multi-record area (on the left-hand side) then it is displayed in the synchronized single-record area (on the right-hand side); this is true whether or not developers have set values for In Display Selection.

 

· Developers can use In Display Selection to move a column from one area to the other.

The default arrangement, and also the default created by using In Display Selection, can of course be overridden or further developed by Web Designer settings.

Summary:

"In Display Selection" column attribute

Result

NULL for all columns within the base table and its supertype table(s) (the default).

In search areas, multi-record result areas and parent areas, only primary key and other key columns (i.e. where Key = 1,2,...) are shown (ordered by Position)

In single-record result areas, all other columns are shown (ordered by Position).

(Numerical) value for at least 1 column within the base table, or within a supertype table of the base table

In search areas, multi-record result areas and parent areas, columns with an "In Display Selection" value are shown (ordered by the In Display Selection attribute).

In single-record result areas, all other columns are shown (ordered by Position)

 

Related Topics:

How to Move a Column Display Between Multi-Record and Single-Record Layout