Retrieving extension table values

To retrieve extension table (matrix) values, use this syntax:


mvals = ObjProperty("FIELD<#>.MATRIX.V\DM<symbol#>", 

Symbol, ObjectKey, RowKey, ColumnKey)
Part Description
Field<#>. MATRIX.V\DM<Symbol#> The first argument is in three parts:

FIELD<#> - Data FIELD name.

Data matrix columns are numbered internally.

Use FIELD with a number suffix that indicates which column in the grid to retrieve, starting with 1.

MATRIX - The name of the detail code.

Symbol and number of the Data Matrix table.

Data Matrix tables are numbered internally. Use “V\DM” followed by the symbol with a table number suffix, starting with 0. The symbol must match the second argument.

Look at the FsDataMatrix table to find the table number. This shows that the Project symbol has two data matrix tables. Use the “VIEW_ID” column as the table number.

Symbol Symbol that matches the symbol in the first argument.

The Symbol argument is used with the third argument, the object key argument. Use these fields to define which system object you are accessing.

Leave either field blank to indicate the current symbol or object key.

ObjectKey Standard. Object key.
RowKey, ColumnKey Criteria for the row filter.

These arguments enable you to filter the rows instead of returning all of the rows. Use an asterisk for the row key argument to return all of the rows.

Or, specify the criteria for which rows to return.

To filter rows, use both arguments to define this criteria:

  • The column to filter by
  • The value to filter by. For example, this syntax returns all of the values in the first column where the third column has the word “APPROVED”.

ObjProperty("FIELD1.MATRIX.V\DMPROJECT2","","","APPROVED",“FIELD3”)

This syntax retrieves all of the values in the first column of the third data matrix table.


Dim tbl As Object
ObjProperty("FIELD1.MATRIX.V\DMPROJECT2","","","*")