Home Search

DriveWorks Pro 21
Rollup Data Table

Send Feedback

Rollup Data Table

Rollup Data Tables are a way to gather data from multiple levels of child specifications and roll them up into a table in a parent specification.

Data is retrieved from Specification Properties in the child project(s).

Automatic linking to Specification Properties is achieved by creating columns in the Rollup Data Table that match the names of Specification Properties in the child project(s).

Only data from specifications that are embedded and synchronized will be retrieved.
Specifications will only be embedded if the root specification is set to embed child specifications.
Specifications will be synchronized if the Child Specification List control that created it is set to continually synchronize with embedded specifications.

Add a Rollup Data Table

With a top level project (a project that contains one or multiple Child Specification List controls that child projects will be specified from) open in DriveWorks Administrator, and:

  1. Select Stage 3: Data and Rules> Define Tables.
  2. Click the Add button from the command bar to add a new table.
  3. Select Rollup Data Table from the list of tables and enter a name.

  4. Click Next.
  5. From the Rollup Data Table Editor, click Add to add a new column.

  6. Enter a name for the column. This must match the name of a Specification Property in a child project to rollup data automatically.

  7. Repeat step 6 above for each item that is required to be included in the rollup table.
  8. Click Finish to apply the Table.

Default Columns

A Rollup Data Table inserts some columns by default, these are:

  • Name - Is the name of the specification the row entry relates to.
  • Type - Is the name of the project the row entry relates to.
  • State - Is the current state of the specification the row entry relates to.
  • Level - Is the level of the specification in the child specification hierarchy that the row entry relates to.
  • Child Specification Control - Is the name of the Child Specification List control the row entry came from.
  • Parent Specification - Is the name of the Parent Specification of the row entry.
  • Row Index - Is the row number of the specification in the Child Specification List control of the row entry.

Any other columns are those added manually using the editor.

Create Placeholder Data

By default Rollup Data Tables will contain no values at design time, as they are populated with specification data.

Rollup Data Tables provide the ability to enter placeholder data when editing the table. This ensures meaningful values will be given when building rules that use the table.

To enter placeholder data:

  1. Select the Rollup Data Table from the list of tables in the Define Tables section.
  2. Click the View/Edit button on the command bar.
  3. This opens the Rollup Data Table in edit mode. Click in a cell and start typing to enter data into the table.
  4. Click OK to finish editing and accept the changes.