additionalData

Displays additional information in columns in separate cells in the formsheet table and is optional.

Usage

Displays additional information in columns in the formsheet table in the form of a list or as plain text.

The additionalData element must be used as a child element of the column element.

Attributes

• name: (Mandatory) Specifies the database name of a property on the object. The source object of parent column element will be referred to as the source object for the additionalData element. You can add DCP properties in the name attribute. Examples: name="GRM(Qfm0FunctionRequirement,WorkspaceObject).object_name"

• id: (Mandatory) Specifies the unique ID for the additional data. The uniqueness of this ID is specific to additionalData, columnGroup and column elements.

• titleKey: (Optional) Specifies the key used for localization. It is used as the title for the additional data.

• list: (Optional) Use this attribute to display additional data in the form of a list, but skip this attribute if you want to display the data as plain text. Depending on the type of list you want, you can provide the value either as ordered or unordered.

• marker: (Optional) This attribute must be used only if the list attribute is present. It specifies the marker type of list. For example, if the list is an unordered list, marker=disc will have a bullet point before each list item.

• sortByProperty: (Optional) Sorts the data of additionalData using the defined property. The sorting is done in context of the source object. Example: Copy<additionalData id="additional_FS_Requirement" titleKey="tc_FS_Requirement" name="GRM(Qfm0FunctionRequirement,WorkspaceObject).object_name" list="unordered" marker="disc" sortByProperty="relation_object.aqc0Order" /> All Qam0QualityAction will be sorted based on qam0Sequence. Data can also be sorted by using relation_object if the source column is rendered using relation sortByProperty="relation_object.aqc0Order".

• sortDirection: (Optional) Specifed the sorting direction of data as ascending or descending. The default value is ascending. The sort direction is considered only if the sortByProperty attribute is defined.

• viewType: (Optional) Lets you view the type for additional data. The supported types are Text and Image. The supported values are ascending or descending. The default value is Text. The Image value is used for rendering the attached image to dataset. Example: Copy<additionalData id="additional_Sys_Ele_Images" titleKey="tc_FS_Images" name="GRM(Aqc0Pictures,Image).awp0ThumbnailImageTicket" list="unordered" marker="disc" viewType="Image"/>

• isModifiable: (Optional) additionalData of column can be configured to allow or disallow modification. The default value is true. If user has the access to modify the property, and the value of isModifiable is set to false, then user cannot modify the property. Example: Copy<additionalData id="additional_Sys_Ele_Images" titleKey="tc_FS_Images" name="GRM(Aqc0Pictures,Image).awp0ThumbnailImageTicket" list="unordered" marker="disc" viewType="Image"/>

Examples

additionalData as a list

Suppose there is a column in the formsheet that displays the function name. Along with the function name, you want to show all the requirements and characteristics linked to this function object in the same cell itself in the form of an unordered list with bullets. To do this, use the additionalData element as follows: Copy<column id="col_Focus_Function_Ele" titleKey="tc_Focus_Element_Function_Requirement" sourceColumn="col_Focus_Sys_Ele.object" name="REF(qfm0FunctionsElementsList,Qfm0FunctionElement).object_name"> <additionalData id="additional_FS_Requirement" titleKey="tc_FS_Requirement" name="GRM(Qfm0FunctionRequirement,WorkspaceObject).object_name" list="unordered" marker="disc" /> <additionalData id="additional_FS_Characteristic" titleKey="tc_FS_Characteristic" name="GRM(Qfm0InspectionDefinition,Aqc0CharElementRevision).object_nam e" list="unordered" marker="disc" /> </column>

To display the `additionalData` as an ordered list having a marker as decimal numbers such as 1,2,3, use the following:
Copy`<column id="col_Focus_Function_Ele"  titleKey="tc_Focus_Element_Function_Requirement"  sourceColumn="col_Focus_Sys_Ele.object"   name="REF(qfm0FunctionsElementsList,Qfm0FunctionElement).object_name">  	<additionalData id="additional_FS_Requirement"  titleKey="tc_FS_Requirement"  name="GRM(Qfm0FunctionRequirement,WorkspaceObject).object_name"  list="ordered" marker="decimal" /> 
	<additionalData id="additional_FS_Characteristic"  titleKey="tc_FS_Characteristic"  name="GRM(Qfm0InspectionDefinition,Aqc0CharElementRevision).object_nam e" list="ordered" marker="decimal" /> 
	</column>`

additionalData as plain text

To display additional data as plain text, the list and marker attributes are not required. In this example, the type of recommended action is shown as additional data where Type is the title and Prevention Action is the data. Copy<column id="col_Recommended_Action" titleKey="tc_FS_Recommended_Actions" sourceColumn="col_Failure_Cause.relation_object" name="REF(qfm0PreventionOptActions,Qam0QualityAction).object_name,REF( qfm0DetectionOptActions,Qam0QualityAction).object_name"> <additionalData id="additional_FS_Action_Type" titleKey="tc_FS_Action_Type" name="qam0QualityActionSubtype"/> </column>

In the following example, the due date and time information is shown as additional data.
Copy`<column id="col_Responsibility_Target_Date"  titleKey="tc_Responsibility_Target_Date"  sourceColumn="col_Recommended_Action.object"   name="fnd0ResponsibleUser"> `
	<additionalData id="col_ Target_Date"  name="qam0DueDate"/> 

`