Sign in

Mapping the Data into the Table

March 12, 2026 02:11 AM
1 min read

The next step is to map the data from the query into the table created in the previous sections. This is done by defining the data that should go into each cell and how the data should be handled by the UI. The UI supports 8 types of data.

Figure 9.

Table 1: The UI-upported data types

Data Type Description
TextDisplays value as plain text
Decimal
Parses the decimal number to display decimal delimiter as either “.” or “,”
Date
Parses the data to display as a date. Supports short/long/date/time
Color
Displays color
ItemDisplays a hyperlink to the specified Item
ListDisplays List property value
FloatDisplays Floating Point Property value
BooleanDisplays Boolean property value
IntegerDisplays an Integer Property value
Note
The following property types currently cannot be mapped into the Tree Grid View definition: Float, Boolean, Image, Color List, Formatted Text, MD5.

Use the following procedure to fill in the sample grid with data:

  1. Double-click in the Part-Name cell and specify the following:

    1. Cell View Type: Text
    2. Text Template: {Part.name}

    Figure 10.

    Note
    Because there is a recursive structure, the Child Part cell also gets the same mapping.

  1. Double-click the CAD Name and Document Name cells and specify the name properties for both.

Figure 11.

  1. Double-click the Part Created By Name cell and set the Text Template as {Part Created By.first_name}{Part Created By.last_name}.

Figure 12.

  1. Map the State properties for Part, CAD, Document, and Simple MCO to the appropriate cells.

Figure 13.

  1. Double-click on the Simple MCO Created On cell and set the following properties:

    1. Cell View Type = Date
    2. Text Template = {Simple MCO.created_on}

Figure 14.

  1. Double-click the top Part Part TGV cell and set the following properties:

    1. Cell View Type: Item
    2. Innovator ItemType Name: Part
    3. Id Template: {CAD.id}
    4. Text Template: {CAD.item_number}

Figure 15.

  1. Repeat these steps to create the same link for CAD Part TGV, Document Part TGV, and Simple MCO Part TGV cells.

    Figure 16.

    Note
    Each item needs the appropriate ArasInnovator ItemType Name and Id Template values.

  1. Repeat the previous steps to create the same link for Part Created By Part TGV cell, but for text display select the login_name property.

Figure 17.

  1. Double-click into the PartBOM-Part TGV cell and set the following: {BOM.related_id/@keyed_name} - Qty: {BOM.quantity}.

Figure 18.

  1. Save the Tree Grid View.

Once you have saved the Tree Grid View, you can export the data to either an Excel file or a Word document by clicking on the appropriate icon in the toolbar. For more information about Cell View Types, refer to Section More About Cell View Types.