Constant for using literals in solution model in relations. |
|
|
The name of the column from the destination table
that this relation item is based on. |
|
The operator that defines the relationship between the primary dataprovider
and the foreign column. |
|
The name of the column from the source table
that this relation item is based on. |
|
|
Returns the comment of this component. |
|
Returns the UUID of this component. |
|
|
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. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample relation.newRelationItem(JSRelationItem.LITERAL_PREFIX + "'hello'",'=', 'mytextfield'); |
|
|
|
|
|
The name of the column from the destination table
that this relation item is based on. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
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. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
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. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
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 = '<'; |
|
|
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
var criteria = relation.newRelationItem(JSRelationItem.LITERAL_PREFIX + "'hello'",'=', 'myTextField');
criteria.primaryLiteral = 'literal_text';
//criteria.primaryLiteral = number;
var primaryLiteral = criteria.primaryLiteral; |
|
|
|
|
|
Returns the comment of this component. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var comment = solutionModel.getForm("my_form").getButton("my_button").getComment();
application.output(comment); |
|
|
|
|
Returns the UUID of this component. |
|
|
Supported Clients SmartClient,WebClient,NGClient |
|
|
Sample var button_uuid = solutionModel.getForm("my_form").getButton("my_button").getUUID();
application.output(button_uuid.toString()); |
|
|
|
|
|
|