The sdidetailmaint Element issues a SQL query and renders the results into
a detail. This Element does not update any records.
Use this Element for rendering detail data that can not be handled by other
detail Elements.
sdidetailmaint
Element Properties
|
| Property Name
|
Description
|
| SQL |
SQL statement to execute for rendering detail data. This supports substitutions
as [currentuser] (UserId currently logged in) and [requestparam] (value
of any request parameter). |
| Tab |
Tab properties:
| 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 | Tab group to which this Element belongs. |
|
| Buttons |
Button properties:
| 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 |
Column properties:
| Property Name | Description | | Identifier | Unique identifier for this item, rendered as an ID attribute in
the HTML tag. | | Column | Identifier of the column to be rendered. This ColumnId must exist
in the SQL query. | | title | title displayed as the column header. | | Width | Width of the column in pixels. | | Align | Alignment of the column (the default is left). | | 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. |
| | 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). | | 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. | | Translate Value | "Yes" translates all values in the column (see Translating
Properties in section 2 Properties Overview). |
|