Property Summery | |
---|---|
String | #foreignColumnName The name of the column from the destination table that this relation item is based on. |
String | #operator The operator that defines the relationship between the primary dataprovider and the foreign column. |
String | #primaryDataProviderID The name of the column from the source table that this relation item is based on. |
Property Details |
---|
foreignColumnName |
The name of the column from the destination table that this relation item is based on. |
Returns String |
Samplevar 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 = '<'; |
operator |
The operator that defines the relationship between the primary dataprovider and the foreign column. |
Returns String |
Samplevar 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 = '<'; |
primaryDataProviderID |
The name of the column from the source table that this relation item is based on. |
Returns String |
Samplevar 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 = '<'; |