The linkedsdimaint Element is used in the MaintenanceForm Page Type to maintain
SDIs linked by foreign key. This Element can add new SDIs, automatically set
a foreign key to the parent SDI, and link existing SDIs to the parent SDI. It
also supports unlinking and deleting SDIs.
linkedsdimaint
Element Properties
|
| Property Name
|
Description
|
| SDC |
Identifier of the primary SDC. This is a mandatory field. |
| Mode |
Specifies either edit (default) or view mode. Edit lets you
add, remove, edit, or re-sequence the child data. View is readonly. |
| Selector Type |
Specifies whether checkboxes or radio buttons are used for
SDI selection. |
| Appearance |
Appearance of the Element. This defaults to Standard. |
| Linked Item Lookup URL |
When dealing with this Element, SDIs exists for the child
SDC, but they are not linked... in other words, children have no foreign
key relationship with the parent SDI. Here you must specify the URL of the
lookup page to open when the "Link" button on the Element is clicked.
This will link the child SDI to the parent SDI. |
| Linked Item Edit URL |
URL of the lookup page to open when you select a record,
then click the "Edit" button. |
| Foreign Key Collection |
Properties for the foreign key collection:
| Property Name | Description | | Identifier | Unique identifier for this item, rendered as an ID attribute in
the HTML tag. | | Column Name | Identifiers of the columns in the SDC that have foreign key relationships
with the parent SDI. This is a mandatory field. | | Request Parameter | Request parameter through which the value of the column can be retrieved.
This is a mandatory field. |
|
| Tab |
Properties of the tab that encloses the Element:
| Property Name | Description | | Show | Yes (default) displays the Element. | | Text | Text displayed in the tab header. | | Width | Width of the tab in pixels (defaults to the size of the tab). | | body Width | Width of the content body (text area beneath the tab). The default
is 100%. | | body Height | Fixed height of the content body. A scrollbar is added as required. | | Expandable | Yes (default) allows the tab to be expanded and collapsed. No disables
this feature and the tab is always expanded. | | Expanded | Yes (default) initially expands the tab if Expandable property is
set to Yes. | | Highlight | Yes (default) highlights the tab on a mouseover event. The CSS defines
this. | | Tip | Help text to appear on mouseover. | | ID | Identifier of the Element (defaults to the Element name). | | Group | Defines a tab group. See Tab
Groups and Field Groups in the maint
Element. |
|
| Button Placement |
Position of the button within the tab. If you leave this
blank, buttons will not be displayed. |
| Buttons |
Properties of the buttons:
| Property Name | Description | | Identifier | Unique identifier for this item, rendered as an ID attribute in
the HTML tag. | | Show | Yes (default) shows the button. | | Text | Text displayed on the button. | | Width | Width of the button in pixels (defaults to the width of the text
on the button). | | Function | JavaScript to execute for an onclick mouse event. | | Tip | Help text to display for an onmouseover button event. | | Image | URL of the image displayed on the button. | | Appearance | Options to select the appearance of the button. If you leave this
blank, it defaults to standard. | | Margin | Margin of the button in pixels. | | style | Choose a style, or specify a CSS if you need to define button style
using a stylesheet. | | Highlight | Yes (default) highlights the button on mouseover. The CSS defines
this. |
|
| Columns |
Properties of the columns:
| Property Name | Description | | Identifier | Unique identifier for this item, rendered as an ID attribute in
the HTML tag. | | Column | Identifier of the column in the Primary SDC. | | title | title displayed as the column header. Clicking the header of a column
selects all fields in that column. | | Width | Width of the column in pixels. | | Align | Alignment of the column (the default is left). | | Mode | Display format of the column (defaults to readonly). | | Validation | Client-side validation rules for text entered into input fields:
| Value | Input Required | | Mandatory | Any string. If you specify Date, Length, Number, Integer,
or Decimal (below), the input must conform to those requirements. | | Date | A LabVantage-defined "date" data
type. | | Length | A LabVantage-defined "string" data
type of specified length. Specify the length within a range.
Range values are inclusive. For example, a range of 6 to 12
means that the string length must be 6, 12, or any integer between. | Number
Integer
Decimal | A LabVantage-defined "number" data
type of the specified kind (number, integer, or decimal) and
length. Specify the length within a range as you would when
specifying a Length (above). |
| NOTE: | The maint Element has built-in client-side validation. The
following varchar fields are rejected:
Columns Containing
SDI KeyId | All Other
Columns | | ' (single quote) | ; (semicolon) | | " (double quote) | | \ (backslash) | | | (pipe) | | ; (semicolon) | | [] (square brackets) |
|
| | Link URL | Specifies attributes of a hyperlinked column: | Property Name | Description | | HRef | URL specifying the destination of the hyperlink (page to open
when clicked). | | Target | Name of the window in which the child page opens in response
to an onclick (default is _self):
| Value | Opens in... | | _self | Same window | | _parent | Caller window | | _blank | New window | | _top | Browser window |
| | Tip | Help text displayed on mouseover. |
| | Pseudo | This is a "pseudocolumn". A pseudocolumn is a column that is rendered
on the page, but does not exist in the SDC. Do not choose a database
columnid when specifying a pseudocolumn. If you want to access this
pseudocolumn using a JavaScript function or another pseudocolumn,
specify an identifier of your own choice.
This value you enter can be HTML, a Variable, or an Expression
(see Variables). For example: | • | If you enter an HTML image tag, then specify a link (using
the Link URL property above), the image becomes a hyperlink. | | • | If you use a variable, the variable must point to one of the
columns defined by the Column
Id property. In this case, you can hide the actual column
so that only the pseudocolumn is displayed. For example, you
could specify Date: [moddt] to display the date and time
a Sample was last modified (such as Date: 8/1/2003 15:36:24),
but only if you have previously chosen moddt as one of
the columns to be rendered. |
| | Display Value | Values displayed in place of the corresponding retrieved values.
Separate each with a semicolon. For example, if you retrieve values
from the createby column, you could specify JDrake=JD. All values
retrieved as JDrake would then be displayed as JD. This works only
if you replace the entire retrieved string (it does not work on partial
strings). | | Link Reftype ID | Specify either a Reference Type identifier, or a semicolon-delimited
list of Reference Values to display in as a dropdownlist or dropdowncombo. | | Lookup URL | URL of the page to open as a lookup. This works only if the Mode
property of the column is "lookup". | | Disable on Save | Yes disables the column when the page initially loads. Any added
row will have this column enabled for editing. By default, the column
is editable. | | Date Format | Format in which date/time is displayed, as determined by the user's
Locale. For information about how LabVantage
handles Locale, see Locale
and Time Zone in the topic Internationalization
and Localization.
The popup calendar and all date validation routines recognize and
function with the chosen format. If you choose a format that specifies only date (without time),
the time defaults to midnight in your time zone. Be advised that
this could be a day earlier for a user in a different time zone.
| | Dropdown SQL | SQL script that retrieves data when the Mode property (above) is
set to dropdownlist. If two columns are selected, the first
column is used as the actual data, and the second column is used as
the Display Value.
For example, if you setup a sampledesc column in dropdownlist
mode, then specify the DropdownSQL script select s_productid, productdesc from s_product the maint Element should render a dropdown list of productdesc
for the sampledesc field. If the query is select s_productid from s_product the Element should render a list of Product SDIs. | | Translate Value | "Yes" translates all values in the column (see Translating
Properties in section 2 Properties Overview). | | Default Value | Value displayed when a new row is added. The default column mode
for this property is "input". | | Dropdown Definition | If the Mode is dropdownlist, this retrieves
data based on an SDC definition:
| Property Name | Description | | SDC Id | The 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 to users. |
| | Display Reference Type | If the "Columns → Mode" is displayicon, this is
the Reference Type that defines the icon displayed. "Display
Reference Type" overrides the Display Value configuration. Display
Value takes effect only if the icon is not found in the Reference
Type. |
|
| Sort by |
Sort order of the detail element rows:
| Property Name | Description | | Identifier | Unique identifier for this item, rendered as an ID attribute in
the HTML tag. | | Column | Identifier of the column by which to sort. | | Order | Sort order (ascending or descending). |
|
| Legend Block |
Specifies properties of a legend used to identify arcane icons:
| Property Name | Description | | New Item Symbol | Icon image file. | | Text | Text that identifies the icon image. |
|
| Restrictive Where Clause |
This is an additional where clause that specifies additional search criteria
for all queries executed from the Element. |
| JavaScript Includes |
JavaScript file to include in the Element. When specified here, the
script does not have to be included in each Page that uses this Element.
| Property Name | Description | | Javascript Source File | URL of the JavaScript (*.js) file to include in the Element. |
|