URL Parameters Accepted by emxGridTable.jsp

These URL parameters can be used to define a dynamic grid using emxGridTable.jsp.

In addition to these parameters, you can also use any parameter supported by emxIndentedTable.jsp. See URL Parameters Accepted by emxIndentedTable.jsp.

URL Parameter Description Possible / Default Values
cellDirection Defines the relationship direction to traverse. Required when cellRelationship is used. from

to

cellIdDirection Defines the relationship direction to traverse. from

to

cellLabel Defines the value of the column cell representing the intersection of the expanded row to the column object.

The value must be an attribute or selectable.

If not defined, the cell is marked with an X to indicate intersection.

Assignee Role

Percent+Allocation

cellLabelType Defines the type for the cellLabel. RelAttr the cellLabel is an attribute on the relationship.

TypeAttr the cellLabel is an attribute on the business object.

RelBasic the cellLabel is a basic selectable on the relationship.

Basic the cellLabel is a basic selectable or the business object.

cellRangeJPO Can be used to identify the cell range values in edit mode. This is standard structure browser functionality and the input/output should be based on the structure browser's definition and requirements. JPO:method
cellRelationship Defines the relationship used to traverse the row data to intersect with the column objects. The data from this relationship becomes the columns unless colRelationship is specified.

You can provide a comma-separated (no space) list of relationships.

Assigned Tasks
cellRelationshipStyle Used to specify the style defined in the CSS for cell coloring and formatting based on the relationship type.

If the relationship specified by this parameter matches the cell relationship, then the style defined is used.

Specified as:

Relationship|Display|Style

The specified Relationship must be one of the relationships specified by the cellRelationship parameter.

Instead of a style, you can replace the cell value with a specified value.

You can provide a pipe-separated list of multiple value sets to define the style for different possible cell values.

The Style can be a pre-defined style in the Indented Table CSS, or the style definition can be provided here.

EBOM|XX|Green|MBOM|ZZ|Blue
cellUpdateJPO Can be used to modify cell entries in edit mode. JPO:method
cellValueStyle Used to specify the style defined in the CSS for cell coloring and formatting based on the cell value. If the cell value matches the Value in the parameter value, then the indicated style is used.

Specified as:

Value|Short Value|Style

For example, in the sample shown, if the cell value is Optional, then the cell is shown in Yellow.

Instead of a style, you can replace the cell value with a specified value.

You can provide a pipe-separated list of multiple value sets to define the style for different possible cell values.

The Style can be a pre-defined style in the Indented Table CSS, or the style definition can be provided here.

Standard|S|Green|Optional|O|Yellow

Standard|S| background-color: lightgreen; text-align:center; font-family: Arial; font-size: 11px; font-weight: bold;

colDirection Defines the relationship direction to traverse for the column objects. Required when colRelationship is used. from

to

colGroup Specifies the column group header. The value must be an attribute or selectable. Project Members
colGroupType Defines the label type for the group header (the source of the field).

The label can be hard coded or specified as a string resource.

RelAttr the colGroup is an attribute on the relationship.

TypeAttr the colGroup is an attribute on the business object.

RelBasic the colGroup is a basic selectable on the relationship.

Basic the colGroup is a basic selectable or the business object.

colHyperlinkTreeCategory Adds a hyperlink to the column object for launching the tree browser for that object. You can specify a Category for the object, or the word Default (indicating the object's default category). Default

Category Name

colJPO Can be used instead of URL parameters to identify column values. The JPO must return a MapList of column objects. JPO:method
colLabel Specifies the label for the column header. By default, the object Name is used. The value must be an attribute or selectable. If you use this parameter, you must also specify the colLabelType parametr. name

revision

colLabelType Defines the label type for the column header (the source of the field).

Required when colLabel is specified.

RelAttr the colLabel is an attribute on the relationship.

TypeAttr the colLabel is an attribute on the business object.

RelBasic the colLabel is a basic selectable on the relationship.

Basic the colLabel is a basic selectable or the business object.

colRelationship Defines the relationship used to traverse the root objects to determine the column objects.

You can provide a comma-separated list (no spaces) of relationships.

If not specified, the column objects will be based on the cell objects defined by cellRelationship.

Division

Member

colType Defines the business object types that are valid for column objects.

You can provide a comma-separated list (no spaces) of types.

This parameters filers the column objects based on types.

Business Unit

Business Unit,Department

flatView Specifies to show the structure browser in flat mode, with no structure. When used, there is no root object and any duplicate row objects are removed. true

false

levelsToDeriveColumnData Number of levels to traverse to determine column objects. Use when column objects are based on cell values to identify the number of levels used to build the column list.

This parameter is not used when colRelationship is specified.

Any integer value
levelsToDeriveRowData Number of levels to traverse row data.

By default, all levels are expanded.

Any integer value
nameSelectable Defines the expression used for the name column to use for searching and filtering. This parameter is required if the name column is not Name AND will be used for the Find and Filter toolbar commands.

To highlight matching rows, the Name column must include these settings:


  • Style Function: getNameStyle
  • Style Program: local:com.matrixone.apps.framework.ui.UITableGrid
 
rowBusWhereClause Defines a where clause to apply during expansion when determining rows. The value can be any valid MQL where clause for the business object.

Using this parameter could result in child objects being filtered out if the where clause filters out parent objects.

 
rowDirection Defines the relationship direction to expand for the rows in the structure browser table. from

to

rowExcludeIntermediateRel Defines the relationship to exclude from the structure browser when the rowRelationship parameter includes intermediate objects.

Only use this parameter if there is an intermediate object for every object in the structure (not a common usage).

 
rowJPO Can be used instead of URL parameters to identify table rows and dynamic cell values. The specified JPO must return a MapList of table rows. JPO:method
rowRelationship Defines the relationships used for expanding the root objects of rows in the structure browser.

You can provide a comma-separated (no space) list of relationships.

Required if the structure browser expansion is URL driven instead of JPO driven.

 
rowRelWhereClause Defines a where clause to apply against relationships during expansion when determining rows. The value can be any valid MQL where clause for the relationship.  
rowType Defines the business object types valid for expanded row objects.

You can provide a comma-separated (no space) list of types.

By default, all types are included.

 
table Defines the structure browser table to use. By default, AEFDynamicGrid is used. AEFDynamicGrid
toolbar Default toolbar is AEFGridFilterToolbar. You can override this toolbar with a custom toolbar, or you can define a custom toolbar in addition to the default toolbar. AEFGridFilterToolbar,MyCustomToolbar
useRowSelectionsAsCols Indicates that rows selected in an existing table are used as columns on the dynamic table view. In this case, the Actions menu command that calls emxGridTable.jsp requires that rows are selected.

If used, the command that calls emxGridTable.jsp must have the Submit=true setting.

When used, the cellRelationship and colRelationship parameters are not used to derive the columns, but cellRelationship is still used to intersect with the columns.

true

false

useRowSelectionsAsRows Indicates that rows selected in an existing table are used as root objects on the dynamic table view. In this case, the Actions menu command that calls emxGridTable.jsp requires that rows are selected. true

false