| Root Properties
|
| SDC |
Identifier of the primary SDC. This is the SDC to be
edited. |
| Fixed columns |
Number of columns that do not scroll if all data does
not fit onto one page. If not defined, all primary SDI columns are fixed. |
| Row selector |
HTML element used to select the row. Choices are checkbox,
radiobutton, or none. This can be used with the getSelectedItems() JavaScript
function. |
| Row level read only rule |
JavaScript rules to be evaluated for every row. If this
returns true, the row is read-only. This supports value substitution
from the primary SDI. For example, "[samplestatus]"=="Completed"
means that the row cannot be edited if the Sample on the row has a Status
of Completed. |
| Columns |
Specifies attributes of primary columns on the grid.
You can use keycolid1, keycolid2, keycolid3 and desccol. These will
be replaced by their respective SDC values.
| Column Properties | | Identification | Unique identifier assigned to the column. | | Column ID | Identifier of the SDI column. This can also be
a SQL select statement. | | Column Type | Specifies how the input form control (generated
HTML input tag) works. These are a subset of the standard options
available with the "Mode"
property in the maint Element. | | title | Text displayed to identify the Column ID. | | title tooltip | Tooltip displayed when the cursor is placed on
the title field. | | Column width | Width of the column header in pixels. | | Input width | Width of the input field in characters. The default
is the database field length. | | Read only rule | JavaScript rules to be evaluated for the field.
If this returns true, the field is read-only. This supports value
substitution from the primary SDI. For example, "[samplestatus]"=="Completed"
means that the field cannot be edited if the Sample has a Status
of Completed. | | Events |
JavaScript function to execute in response to a DHTML event
occurring on the form control.
| Event Properties | | Identification | Unique identifier assigned to the event. | | Event type | DHTML event that executes the JavaScript
function. | | Function | JavaScript function to execute in response
to the event. |
| | Translate | If set to Yes, the value can be translated. | | Date only |
Format in which date/time are displayed, as determined by the
User's Locale. Choices are:
| • | Dateonly (displays date without time). | | • | Datetime (displays both date and time). | | • | Smart (displays date but time is hidden if it is 00:00). |
| | Mandatory | If set to Yes, the form cannot be saved unless
a value is entered into this field. | | Validation | Client-side validation rules for text entered
into the field. This is similar to the "Validation"
property in the maint Element. | | Reference Type | If the Column Type is set to dropdownlist or dropdowncombo,
this is the Reference Type that defines the selectable values. | | Dropdown SQL | If the Column Type is set to dropdownlist, this
is the SQL script that retrieves data. This supports value substitution
from the primary SDI. | | Dropdown definition |
If the Column Type is set to dropdownlist, this retrieves data
based on an SDC definition:
| Root Properties | | SDC Id | SDC for which data is retrieved. | | Query From | Value of the From clause for the query.
| | Query Where | Value of the Where clause for the query.
| | Query Order By | Value of the Order By clause for the query.
| | Value Column | Actual column value. | | Display Column | Column value displayed. |
| | Lookup properties |
If the Column Type is lookup, this defines the Lookup page.
| Root Properties | | Lookup page | URL to which the Lookup icon is linked. | | Lookup SDC | SDC used for the Lookup page. | | Restrictive where | Optional restrictive where clause that either
combines with the provided List page's restrictive where
clause, or is used as the primary restrictive where clause
on the default Lookup page. | | Dynamic lookup | Enables the field for Dynamic
Lookup. | | Lookup columns | Columns that are either merged with the
List page specified by the URL in the Link property, or
(if not specified by the Link property) used to define a
new List page.
| Column Properties | | Identification | Unique identifier assigned to the
item. | | Column Id | If merging with an existing List page,
if no match can be found for the identifier, this
tries to match on a column id. If a match is still
not found, a new column is created. | | title | title of the column. | | Mode | Specifies how the column is populated:
| • | Display Only (show the value, but do not
populate the column). | | • | Return Only (populate the column, but do not
show the value). | | • | Display and Return (show the value and populate
the column). | | • | Hidden Only (hidden field). |
| | Display value | Value displayed in place of the corresponding
retrieved value (see "Display
Value" in the maint Element for an example).
| | Pseudo column | See "Pseudo
Column" in the maint Element for an example. | | Map to column | If you return more than one column,
use this to specify the destination of the returned
values. | | Width | Column width in pixels. | | Searchable | Determines if the value in the Dynamic
Lookup is searchable. |
|
| | Pseudo | See "Pseudo
Column" in the maint Element for an example. | | Display value | Value displayed in place of the corresponding
retrieved value (see "Display
Value" in the maint Element for an example). | | Link | Specifies the URL of the Lookup page. Click the
ellipsis button, then specify the URL as a call to the Request
Controller. | | Link target | Name of the window in which the linked page opens.
You can enter any name here, and the new window (browser instance)
will automatically assume that name. If you do not specify a target,
the linked page opens in the current window. |
|
| Detail collection |
Defines the secondary SDI columns, which are displayed
after the primary SDC columns. For example, if you use "Manage
Data Sets" for multiple Samples in the Sample List page, this would
define the SDIData (see the ManyToManyMaint
Page Type).
| Root Properties | | Detail collection type | Defines the SDC or SDI relationship:
| • | manytomany (supports any many-to-many defined in the
SDC configuration). | | • | sdidetail (supports the limited set of SDI details: sdiworkitem,
sdidata, sdispec, sdirole, category, and sdidataitem). |
See the ManyToManyMaint
Page Type for examples. | | Detail link | If Detail collection type is manytomany, this
is the identifier of the link. | | Detail collection dataset | If Detail collection type is sdidetail, this defines
the detail collection content (sdiworkitem, sdidata, sdispec,
sdirole, category, or sdidataitem). | | Retrieve mode | Determines which SDIs are retrieved:
| • | Union retrieves only secondary SDIs that are already
linked to primary SDIs. | | • | All SDIs retrieves all secondary SDIs. |
| | Restrictive where | If all SDIs are retrived, you can use this where
clause to filter. | | Detail header | Secondary SDC column header. If left blank, no
secondary header is displayed. This supports substitution from
the secondary SDC key columns plus columns defined in the "Secondary
SDC columns" property below. | | Detail header width | Width of the Detail header in pixels. | | Detail header height | Height of the Detail header in pixels. Leave this
blank if title rotation (below) is 0. | | title rotation | Rotation of the title text in degrees. Choices
are 0 or 90 degrees. | | Inverse rotation in RTL mode | Mirrors the title rotation in right-to-left display
mode. | | Detail disabled rule | JavaScript rule to evaluate for each checkbox.
If this returns true, the detail cell is disabled. This rule supports
value substitution from the detail table. | | Tooltip | Tooltip that is shown when hovering over detail
cell. This supports value substitution from the detail table (such
as "[workitemstatus]"). | | Add secondary | Yes adds a button to the upper right corner of
the grid. Clicking the button adds a new secondary SDI. This has
been tested only with Categories. | | Order buttons | Yes adds left and right arrow buttons to each
detail cell header column. This lets you move detail items to
the left and right. | | Apply WorkItem | Yes applies SDIWorkitems when they are added (see
Adding
Versus Applying Tests). | | Detail lookup | Defines the attributes of the new detail lookup
column.
| Root Properties | | Lookup page | Specifies the URL of the Lookup page. Click
the ellipsis button, then specify the URL as a call to the
Request Controller. | | Lookup SDC | SDC used for the Lookup. | | Extended where | Extended where clause to use as a filter. | | Dynamic lookup | Yes makes the page a Dynamic
Lookup. | | Lookup columns | Defines the Detail lookup columns.
| Column Properties | | Id | Unique identifier assigned to the
item. | | Column Id | Identifier of the column. | | title | title of the column. | | Mode | Specifies how the column is populated:
| • | Display Only (show the value, but do not
populate the column). | | • | Return Only (populate the column, but do not
show the value). | | • | Display and Return (show the value and populate
the column). | | • | Hidden Only (hidden field). |
| | Display value | Value displayed in place of the corresponding
retrieved value (see "Display
Value" in the maint Element for an example).
| | Pseudo column | See "Pseudo
Column" in the maint Element for an example. | | Map to column | If you return more than one column,
use this to specify the destination of the returned
values. | | Width | Column width in pixels. | | Searchable | Determines if the value in the Dynamic
Lookup is searchable. |
|
| | Read only rule | JavaScript rule to evaluate. If this returns true,
editing of all details is disabled. This is useful to managing
User-Roles. | | Secondary SDC columns | Extra columns (other than secondary key columns)
such as "Description". These can be used in "Detail
header" property substitution.
| Column Properties | | Id | Unique identifier for this column. | | Column id | Identifier of the extra column to add. You
can enter a Column id or SQL sub-query. | | Translate | Yes allows Translation. |
| | Detail columns | These detail columns are taken from the manytomany
or sdidetail table (such as sdiworkitem). TheColumn type may be
hidden, read-only, or input. Input means that the column is editable.
Extra editor properties can be defined by selecting an Editor
style.
| Column Properties | | Id | Unique identifier for this column. | | Column id | Identifier of the column in the detail table. | | Column type | Determines the column mode:
Note that "input" is the only editable choice.
Extra editor properties can be defined by selecting an
Editor style. | | title | title of the column. | | Input width | Width of the column in pixels. | | Editor style | If the Column type is "input",
you can choose an Editor
style to use. | | Translate | Yes allows Translation. |
| | styles | Determines styles used for display. | Root Properties | | Status colors | Yes uses default status colors for sdidata
and sdiworkitem data. No lets you define other styles below. | | styles | Defines alternate styles.
| style Properties | | Column ID | Identifier of the column in the detail
table. | | Value | Column value. | | Background color | Background color to apply when detail
table value matches. |
|
|
|
| Tab |
Defines the detail tabs.
| Root Properties | | Show | Determines if the tab is shown. | | Text | Text displayed on the tab. | | Tip | Tooltip displayed when hovering over the tab. | | body width | Not supported. | | body height | Not supported. | | Group | Determines whether tab group is top or bottom. | | Show single tab header | No hides the tab header when it is the only tab
in the group. |
|
|
