Mapping the Data into the Table

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

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.

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

Figure 11.

3. 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.

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

Figure 13.

5. 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.

6. 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.

7. 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.

8. 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.

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

Figure 18.

10. 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.