DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.
Enter additional information related to this 'class' inside the {div} macro with 'id=description'
{column:width=80px|padding=0px}{column}{column}{column}
Constants Summary
LITERAL_PREFIX
Constant for using literals in solution model in relations.
{column:width=80px|padding=0px}{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:width=80px|padding=0px}{column}{column}{column}
Method Summary
{column:width=100%|padding=0px}{column}
Constants Details
Constant for using literals in solution model in relations.
Strings must be passed as quoted value to make a distinction between string '5' and number 5.
Sample
relation.newRelationItem(JSRelationItem.LITERAL_PREFIX + "'hello'",'=', 'mytextfield');
{column:width=100%|padding=0px}{column}
Property Details
The name of the column from the destination table
that this relation item is based on.
Sample
var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/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.
Sample
var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/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.
Sample
var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/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:width=100%|padding=0px}{column}
Method Details
Returns the UUID of this component.
Sample
var button_uuid = solutionModel.getForm("my_form").getButton("my_button").getUUID(); application.output(button_uuid.toString());