{column:padding=0px|width=80px}{column}{column}{column}
Property Summary
foreignColumnName
The name of the column from the destination table
that this relation item is based on.
primaryDataProviderID
The name of the column from the source table
that this relation item is based on.
{column:padding=0px|width=80px}{column}{column}{column}
Method Summary
{column:padding=0px|width=100%}{column}
Property Details
The name of the column from the destination table
that this relation item is based on.
Returns
String
Sample
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN); var criteria = relation.newRelationItem('parent_table_id', '=', 'child_table_parent_id'); criteria.primaryDataProviderID = 'parent_table_text'; criteria.foreignColumnName = 'child_table_text'; criteria.operator = '<';
The operator that defines the relationship between the primary dataprovider
and the foreign column.
Returns
String
Sample
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN); var criteria = relation.newRelationItem('parent_table_id', '=', 'child_table_parent_id'); criteria.primaryDataProviderID = 'parent_table_text'; criteria.foreignColumnName = 'child_table_text'; criteria.operator = '<';
The name of the column from the source table
that this relation item is based on.
Returns
String
Sample
var relation = solutionModel.newRelation('parentToChild', 'example_data', 'parent_table', 'example_data', 'child_table', JSRelation.INNER_JOIN); var criteria = relation.newRelationItem('parent_table_id', '=', 'child_table_parent_id'); criteria.primaryDataProviderID = 'parent_table_text'; criteria.foreignColumnName = 'child_table_text'; criteria.operator = '<';
{column:padding=0px|width=100%}{column}
Method Details
Returns the UUID of this component.
Returns
UUID
Sample
var button_uuid = solutionModel.getForm("my_form").getButton("my_button").getUUID(); application.output(button_uuid.toString());