Applications → Working with Forms → Form Settings → Widget Settings → Relational Grid Widget
This topic describes Relational Grid widget settings. For details on using the widget, refer to Using the Relational Grid Widget.
The following table describes the fields on the General tab of the Property Editor for this widget.
|Name||Type the name by which the widget is uniquely identified. No other widget or control on this form can have the same name.|
|Caption||Type the text to appear in the title bar
above the widget.
If you leave this field blank, the widget will not have a title bar.
|Report||Displays the name of the configured report.
If none has been configured, click
Configure Report, and complete the
dialog box that opens as described in
Relational Grid Configuration Dialog Box.
Click Clear to remove the configuration and start over.
Border: Select this check box to draw a thin line around the widget.
Scroll bars: Select this check box to include scroll bars in the widget. This provides more content than the allotted space.
Check box selection: Select this option to place check boxes next to each row in the report. If the check box is cleared, users select multiple items by using the CTRL key. This option is only available for widgets based on Multi-Relational fields.
Radio button selection: Select this option to use a radio button to make the selection. If this check box is cleared, users select the item by clicking on it (which is not as visually obvious as the radio button). This option is only available for widgets based on Single Relational fields.
Title: Select this option to show the title ("Report for field relational field") in the relational grid header.
Details: Select this option to show item count and applied filters in the relational grid header.
Requery: Select this check box to show the Requery link in the relational grid footer.
Select/Unselect all: Select this option to show the Select All and Unselect All links in the relational grid footer. This option is only available on transition or edit forms, and for widgets based on Multi-Relational fields.
Clear: Select this option to show the Clear link in the relational grid footer. This option is only available on transition or edit forms.
Show only selected item: Select yes to show only the items the user has currently selected in the relational grid or no to show all items. For transition forms, the additional option if read only limits the relational grid to show the selected read-only items as well as editable items.
Display 'Show only selected items' checkbox: Select an option to show or hide the Show only selected items checkbox in the relational grid footer. For transition forms, the additional options if editable and if read only enable you to show the checkbox depending on if the items in the relational grid are editable or read only.
|Description||Type an optional description of the widget.|
You can select one of the following options:
|SBM Composer report definitions based on a primary table|
|FIELD_NAME||Set values for the query-at-runtime
parameters for the report. You can use static values or be bound to other field
or control values. See
Using the String Builder Tool
for information about binding values.
Important: When you bind certain types of fields, two binding values are presented: fieldname and fieldname[ID]. When you bind to a field that has been configured with the Query at Runtime search feature, you should use fieldname[ID] if it is available.
|SBM Composer report definitions and SBM Work Center or SBM User Workspace reports|
|Searchable||Enables users to filter the contents of the
relational grid by entering a value for a specific field. To be searchable, the
field must be defined as a column and as a query-at-runtime search filter in
the report definition.
The following fields and field types are searchable: Item Id, Text, Project, Company, User, Multi-User, Multi-Group, Single Selection, Multi-Selection, Folder, and Numeric (exact value, not "contains").
These field types are not searchable: File, URL, Single Relational, Multi-Relational, and Sub-Relational.
Note: If a field is used multiple times as a search filter, you cannot make it searchable. This prevents confusion about which search filter is being applied to the grid.
|SBM Composer report definitions|
See Widget Refresh Tab.
Copyright © 2007–2018 Serena Software, Inc., a Micro Focus company. All rights reserved.