Table Control

Table control is used to show relationship or reference data of the context item. As part of adding table control to the form, Aras ProAppDesigner shows Settings flyout where you can configure the RelationshipType or ReferenceType that you want to associate with the table control. RelationshipType or ReferenceType can only be selected at the time of adding table control. If you need to change the associated RelationshipType or ReferenceType, then you need to delete table control and re-add it. Table control has multiple settings that controls its appearance and behavior at runtime.

When ReferenceType option is selected for creating Table control, a dropdown will be shown with all ItemTypes on which context ItemType is defined as item property. If there are multiple item properties of the context ItemType on the selected ItemType, a dropdown will be shown to select the specific item property.

When Type option is selected for creating Table control, a dropdown will be shown with all ItemTypes available in the system. At runtime, table shows rows of the items from the configured ItemType. By default, it doesn’t show any rows. In order to see the rows, you have to set the property filter and click on the Search icon. This table configuration can be used to show table in the flyout and let user select specific item after performing search with the filter.

You can also configure individual columns on the table control by selecting gear icon from the column. You can set Validation Rules, Default Value, Conditional Formatting, Read Only on the individual column by selecting gear icon from the column that opens Settings flyout. While defining expressions on the individual columns, you will only see properties from other columns of the same table control.

• Name: It is used to uniquely identify control inside the template.
• Label: It is used to show title on the table. It can be localized by defined Languages and Locales inside innovator.
• Columns: Using Columns settings section, you can add all the required columns to the table. Columns can be added based on the RelationshipType or RelatedItemType properties. Using Column Width option, you can set column widths in percentage or pixels. If you select Column Width as Percentage, you never see horizontal scrollbar, widths of the columns will get adjusted to the available total width of the table. If Column Width option is selected as Pixels, you will see horizontal scrollbar if the combined widths of all columns is more than available table width. In pixel mode, columns can be reordered and resized at runtime. As part of adding column, you need to select the property from either RelationshipType or RelatedItemType, to which you want to bind the column. Columns added with RelatedItemType properties will be shown with (RI) in the column name. After adding columns, you can edit Width of the column, or you can reorder column using drag-drop icon from the Actions columns. You can hide or show column by selecting the checkbox under Hide column. You can delete existing column by selecting delete icon from the Actions column. By setting Freeze Column option, you can fix columns that are always visible and don’t move along with horizontal scrollbar. Freeze Column option is shown only in the Column Width Pixels mode.
• Insert Filter: It allows you to define the filter criteria for Insert Flyout. As an admin, you can define filter criteria that is used when the Insert Flyout is opened. As an admin, you can also enforce the filter, in that case end-user can see the applied filter on the Insert Flyout, but can’t change the filter criteria. If enforce filter is not set, end-user can change the filter criteria at the runtime.
• Insert Columns: It allows you to define the columns that need to be shown on the Insert Flyout. You can also define the width of the Flyout in percentage with respect to main page.

• Commands: Using Commands section, you can show or hide standard commands shown on the Table toolbar. You can also define custom command by selecting Type as Button or DropDown and entering command name. For each custom command, you can set On Click, Can Show, On Load options.
  Each custom command can be configured with ‘On Click’ handler to perform certain action. It can show a shortcut to the existing Innovator actions like Structure Browser, Where Used, Workflow Signoffs etc. It can also be configured to call a custom script. By selecting Script option in the dialog, you can associate custom script that contains code to interact with other Table columns or controls in the Wizard. Script can also have code to interact with server by sending a request.
  Each custom command can be configured with ‘Can Show’ option to define custom JavaScript that will return a boolean value. If returned value is true, command will be shown otherwise command will be hidden.
  Each custom command of type ‘DropDown’ can be configured with ‘On Load’ option to load options for the DropDown at runtime.
  For each command, you can configure icon. You can also show or hide the command by selecting checkbox under Hide column.

  

  

  

  

• Cascade Delete: It facilitates all child relationships and related items to be deleted when the parent item is deleted.
  
  • Cascade Delete: Yes
    If ‘Cascade Delete’ is set to Yes, when the context item is deleted, all the child items in the table will get deleted. In order to edit any row in the table, you don’t have to lock the row, if the context item is in the edit mode, all child items can be edited without applying the lock.
  • Cascade Delete: No
    If ‘Cascade Delete’ is set to No, for editing any child item, first you have to apply the lock. Also, deleting the context item won’t delete child items in the table.
• Scroll Mode: Table control in Aras ProAppDesigner can be shown in two distinct modes, with pagination or scroll.
  
  • Scroll Mode: Yes
    If ‘Scroll Mode’ is set to Yes, table will always be shown with scroll to facilitate row reordering with drag-drop.
  • Scroll Mode: No
    If ‘Scroll Mode’ is set to No, table will always be shown with pagination.
• Height: Table control can be rendered in three different mode for the Height.
  
  • Height: Explicit
    In this mode, ‘Max Height’ should be supplied to limit the height of the table in the page. Table auto grows until it reaches ‘Max Height’, after that it shows scrollbar for the body of the table.
  • Height: Fit to Content
    In this mode, table control grows its height without showing any scrollbar. If it doesn’t get required height by the page, then page will start showing scrollbar.
  • Height: Automatic
    In this mode, table controls auto grows until it reaches available page height, after that it shows scrollbar for the body of the table. This mode can be set on the table control only when the page that contains table control has only simple form fields apart from this table control.
• Related Option: It controls how new rows can be added to the table. This option is defined on the RelationshipType inside innovator, and it is read-only.
  There are three options available:
  
  • Pick only: You can select the Item which is already present.
  • Create only: You needs to create the Item.
  • Pick and Create: You can either select the existing Item or create a new Item.
• Show Label: It controls whether Label can be shown at the top of the table control.
• Access: It allows you to define roles which can access control. Roles (in the form group identities) can be at Show and Edit level. When control is hidden because user doesn’t have defined role, relationship data associated with this control is not even fetched from server.
• Read Only: Based on the option selected for Read Only, control can become read-only even if you can edit the properties used inside the page with lock. You can select one of the options like ‘Yes’, ‘No’, ‘Expression’, or ‘Script’. Expression allows you to define a Boolean expression using properties from the current and previous pages (in case of multi-page application) to conditionally make the control read-only if expression is evaluated to true. Expression will be evaluated based on the cached property values on the client. Script allows you to write custom JavaScript code that should return Boolean value. If returned value is true, the control will be read-only.
• Display Condition: Based on the option selected for Display Condition, the control will be shown or hidden in the wizard at runtime. You can select one of the options like ‘Always Show’, ‘Always Hide’, ‘Expression’, or ‘Script’. Expression allows you to define a Boolean expression using properties from the current and previous pages (in case of multi-page application) to conditionally display the control if expression is evaluated to true. Expression will be evaluated based on the cached property values on the client. Script allows you to write custom JavaScript code that should return Boolean value. If returned value is false, the control will be hidden.
• Margin: It allows you to set the required top, right, bottom, left margins with respect to adjacent controls.
• On Before Load: OnBeforeLoad event allows you to write custom logic that will be executed before the data in the control is loaded. This will be useful to set the filter expression before loading the data. Please refer to the Template Customization section for more details.
• On Load: OnLoad event allows you to write custom logic that will be executed after the data in the control is loaded. Please refer to the Template Customization section for more details.
• On Insert: OnInsert event will be launched after item has been inserted in the Table control. Event handler will receive inserted item details via eventData, this object will be available in the scope of the event handler code. Please refer to the Template Customization section for more details.
• On Insert Filter: On Insert Filter event will be launched after hitting the search button in Insert Item flyout. Admin can configure a custom script to modify entered filter expression or assign entirely new filter expression string to the eventData. EventData object is available in the scope of the event handler code. Please refer to the Template Customization section for more details.

• On Select: On Select event will be launched after selecting the item in the Table control. Event handler will receive selected item details via eventData, this object will be available in the scope of the event handler code. Please refer to the Template Customization section for more details.