AX1579
Axiom.ProductColumns
The Axiom.ProductColumns system table can be used to report on the columns that belong to a particular product. Table columns can be assigned to one or more Axiom Financial Institutions Suite products by using product data sets.
Available columns
The following columns can be queried:
| Column | Description |
|---|---|
|
ColumnDefinitionID |
The database ID of the column. |
|
ColumnName |
The name of the column. |
|
QualifiedFriendlyName |
The fully qualified name of the column, in Table.Column format. |
|
ParentColumnName |
The name of the column's assigned lookup column, in fully-qualified format (Table.Column). Returns blank if the column does not have a lookup column. |
|
TableName |
The name of the table that the column belongs to. |
|
DataSetName |
The name of the product data set that the column belongs to. If the column does not belong to any product data sets, this field returns blank for that column. If a column belongs to multiple data sets, then the query will return one column record per data set. For example, if a column belongs to two different data sets, then the query will include two records for that column, one for each data set name (assuming that both data sets are being returned by the query). In other words, the DataSetName field does not return a comma-separated list of all data sets that a column belongs to. |
|
ColumnSetItemID |
The database ID of the data set item. Returns 0 if the column does not belong to any product data sets. |
|
SortOrder |
The sort order of the column within the table. |
Remarks
When querying Axiom.ProductColumns, you may want to include a filter that limits the query by table and/or by product data set. For example:
TableName='Dept' and DataSetName IN ('CapPlan', '')
This filters the query to return all columns in table Dept that are not assigned to any data set, as well as all columns that belong to the CapPlan data set. This could be used to provide a list of columns that are used by the Capital Planning product, using the assumption that unassigned columns apply to all products.
Additionally, the "sum by" can be used to group the query by particular fields, such as TableName or DataSetName. For example, you could sum by TableName and filter the query by a particular data set name, in order to return a list of all tables that have columns belonging to that data set. The default sum level is ColumnDefinitionID. This is notable because normally the sum by should be left blank when querying a system table.
Save Type 4 support
Axiom.ProductColumns cannot be modified using Save Type 4.
