Page History

{hidden}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE{hidden}
{sub-section:description|text=}{sub-section}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}PropertyConstants Summary{th}{tr}{tbody}{tr}{td}[String]{td}{td}[#foreignColumnName#LITERAL_PREFIX]
TheConstant namefor ofusing theliterals columnin fromsolution themodel destination table
that this relation item is based onin relations.{td}{tr}{tbody}{tbodytable}{tr\\ 

{table:id=|class=servoy sSummary}{tdcolgroup}[String]{td}{td}[#operator]
The operator that defines the relationship between the primary dataprovider
and the foreign column.{td}{tr}{tbody{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property Summary{th}{tr}{tbody}{tr}{td}[String]{td}{td}[#primaryDataProviderID#foreignColumnName]
The name of the column from the sourcedestination table

that this relation item is based on.{td}{tr}{tbody}{tabletbody}\\ 

{table:id=|class=servoy sSummary{tr}{colgrouptd}{column:padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr[String]{td}{td}[#operator]
The operator that defines the relationship between the primary dataprovider
and the foreign column.{td}{tr}{tbody}{tbody}{tr}{td}[ObjectString]{td}{td}[#getDesignTimeProperty]\()
Get a design\-time property of an element#primaryDataProviderID]
The name of the column from the source table 
that this relation item is based on.{td}{tr}{tbody}{tbody}{tr}{td}[UUID]{td}{td}[#getUUID]\()
Returns the UUID of this component.{td}{tr}{tbody}{tbody}{tr}{td}[Object]{td}{td}[#putDesignTimeProperty]\()
Set a design\-time property of an element.{tdtable}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tbody}{tr}{td}[ObjectUUID]{td}{td}[#removeDesignTimeProperty#getUUID]\()
ClearReturns a design\-time property the UUID of anthis elementcomponent.{td}{tr}{tbody}{table}\\ 

{table:id=propertyconstant|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}PropertyConstants Details{th}{tr}{tbody:id=foreignColumnNameLITERAL_PREFIX|class=node}{tr:id=name}{td}h6.foreignColumnNameLITERAL_PREFIX{td}{tr}{tr:id=des}{td}{sub-section:foreignColumnNameLITERAL_PREFIX_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:foreignColumnNameLITERAL_PREFIX_des|trigger=none|class=sIndent}The name of the column from the destination table
that this relation item is based on.{sub-section}{td}{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.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:foreignColumnNameLITERAL_PREFIX_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:foreignColumnNameLITERAL_PREFIX_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:foreignColumnNameLITERAL_PREFIX_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:foreignColumnNameLITERAL_PREFIX_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:foreignColumnNameLITERAL_PREFIX_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:foreignColumnNameLITERAL_PREFIX_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:foreignColumnNameLITERAL_PREFIX_see|text=|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:foreignColumnNameLITERAL_PREFIX_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:foreignColumnNameLITERAL_PREFIX_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:foreignColumnNameLITERAL_PREFIX_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:foreignColumnNameLITERAL_PREFIX_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:foreignColumnNameLITERAL_PREFIX_sam|trigger=none}{code:language=javascript}
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 = '<';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td.newRelationItem(JSRelationItem.LITERAL_PREFIX + "'hello'",'=', 'mytextfield');
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:id=property|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Property Details{th}{tr}{tbody}{tbody:id=operatorforeignColumnName|class=node}{tr:id=name}{td}h6.operatorforeignColumnName{td}{tr}{tr:id=des}{td}{sub-section:operatorforeignColumnName_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:operatorforeignColumnName_des|trigger=none|class=sIndent}The operator that definesname of the column from the relationshipdestination betweentable
thethat primarythis dataproviderrelation anditem theis foreignbased columnon.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:operatorforeignColumnName_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:operatorforeignColumnName_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:operatorforeignColumnName_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:operatorforeignColumnName_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:operatorforeignColumnName_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:operatorforeignColumnName_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:operatorforeignColumnName_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:operatorforeignColumnName_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:operatorforeignColumnName_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:operatorforeignColumnName_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:operatorforeignColumnName_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:operatorforeignColumnName_sam|trigger=none}{code:language=javascript}
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 = '<';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=primaryDataProviderIDoperator|class=node}{tr:id=name}{td}h6.primaryDataProviderIDoperator{td}{tr}{tr:id=des}{td}{sub-section:primaryDataProviderIDoperator_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:primaryDataProviderIDoperator_des|trigger=none|class=sIndent}The nameoperator that ofdefines the columnrelationship frombetween the sourceprimary tabledataprovider
and thatthe this relation item is based onforeign column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:primaryDataProviderIDoperator_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:primaryDataProviderIDoperator_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:primaryDataProviderIDoperator_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:primaryDataProviderIDoperator_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:primaryDataProviderIDoperator_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:primaryDataProviderIDoperator_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:primaryDataProviderIDoperator_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:primaryDataProviderIDoperator_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:primaryDataProviderIDoperator_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:primaryDataProviderIDoperator_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:primaryDataProviderIDoperator_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:primaryDataProviderIDoperator_sam|trigger=none}{code:language=javascript}
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 = '<';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:id=function|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=getDesignTimeProperty|class=node}{tr:id=name}{td}h6.getDesignTimeProperty{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Object]{span}{span:id=iets|style=float: left; font-weight: bold;}getDesignTimeProperty{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getDesignTimeProperty_des|text=|trigger=button}{sub-section}{sub-section:getDesignTimeProperty_des|trigger=none|class=sIndent}Get a design\-time property of an element.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getDesignTimeProperty_snc|text=|trigger=button}{sub-section}{sub-section:getDesignTimeProperty_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getDesignTimeProperty_prs|text=|trigger=button}{sub-section}{sub-section:getDesignTimeProperty_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getDesignTimeProperty_ret|text=|trigger=button}{sub-section}{sub-section:getDesignTimeProperty_ret|trigger=none|class=sIndent}[Object]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getDesignTimeProperty_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDesignTimeProperty_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getDesignTimeProperty_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDesignTimeProperty_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getDesignTimeProperty_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDesignTimeProperty_sam|trigger=none}{code:language=javascript}
var frm = solutionModel.getForm('orders')
var fld = frm.getField('fld')
var prop = fld.getDesignTimeProperty('myprop')
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getUUID|class=node}{tr:id=name}{td}h6.getUUID{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[UUID]{span}{span:id=iets|style=float: left; font-weight: bold;}getUUID{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getUUID_des|text=|trigger=button}{sub-section}{sub-section:getUUID_des|trigger=none|class=sIndent}Returns the UUID of this component.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getUUID_snc|text=|trigger=button}{sub-section}{sub-section:getUUID_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getUUID_prs|text=|trigger=button}{sub-section}{sub-section:getUUID_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getUUID_ret|text=|trigger=button}{sub-section}{sub-section:getUUID_ret|trigger=none|class=sIndent}[UUID]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getUUID_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getUUID_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getUUID_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getUUID_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getUUID_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getUUID_sam|trigger=none}{code:language=javascript}
var button_uuid = solutionModel.getForm("my_form").getButton("my_button").getUUID();
application.output(button_uuid.toString());
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=putDesignTimeProperty|class=node}{tr:id=name}{td}h6.putDesignTimeProperty{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Object]{span}{span:id=iets|style=float: left; font-weight: bold;}putDesignTimeProperty{span}{span:id=iets|style=float: left;}\(){span} = '<';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=primaryDataProviderID|class=node}{tr:id=name}{td}h6.primaryDataProviderID{td}{tr}{tr:id=des}{td}{sub-section:putDesignTimePropertyprimaryDataProviderID_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:putDesignTimePropertyprimaryDataProviderID_des|trigger=none|class=sIndent}Set a design\-time property of an element=none|class=sIndent}The name of the column from the source table 
that this relation item is based on.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:putDesignTimePropertyprimaryDataProviderID_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:putDesignTimePropertyprimaryDataProviderID_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:putDesignTimePropertyprimaryDataProviderID_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:putDesignTimePropertyprimaryDataProviderID_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:putDesignTimePropertyprimaryDataProviderID_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:putDesignTimePropertyprimaryDataProviderID_ret|trigger=none|class=sIndent}[ObjectString]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:putDesignTimePropertyprimaryDataProviderID_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:putDesignTimePropertyprimaryDataProviderID_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:putDesignTimePropertyprimaryDataProviderID_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:putDesignTimePropertyprimaryDataProviderID_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:putDesignTimePropertyprimaryDataProviderID_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:putDesignTimePropertyprimaryDataProviderID_sam|trigger=none}{code:language=javascript}}
var relation = solutionModel.newRelation('parentToChild', 'db:/example_data/parent_table', 'db:/example_data/child_table', JSRelation.INNER_JOIN);
var frmcriteria = solutionModelrelation.getForm('orders')
var fld = frm.getField('fld')
fld.putDesignTimeProperty('myprop', 'strawberry')newRelationItem('parent_table_id', '=', 'child_table_parent_id');
criteria.primaryDataProviderID = 'parent_table_text';
criteria.foreignColumnName = 'child_table_text';
criteria.operator = '<';
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:id=function|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=removeDesignTimePropertygetUUID|class=node}{tr:id=name}{td}h6.removeDesignTimePropertygetUUID{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[ObjectUUID]{span}{span:id=iets|style=float: left; font-weight: bold;}removeDesignTimePropertygetUUID{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:removeDesignTimePropertygetUUID_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:removeDesignTimePropertygetUUID_des|trigger=none|class=sIndent}ClearReturns a design\-time propertythe UUID of anthis elementcomponent.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:removeDesignTimePropertygetUUID_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:removeDesignTimePropertygetUUID_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:removeDesignTimePropertygetUUID_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:removeDesignTimePropertygetUUID_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:removeDesignTimePropertygetUUID_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:removeDesignTimePropertygetUUID_ret|trigger=none|class=sIndent}[ObjectUUID]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:removeDesignTimePropertygetUUID_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:removeDesignTimePropertygetUUID_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:removeDesignTimePropertygetUUID_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:removeDesignTimePropertygetUUID_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:removeDesignTimePropertygetUUID_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:removeDesignTimePropertygetUUID_sam|trigger=none}{code:language=javascript}
var frmbutton_uuid = solutionModel.getForm('orders')
var fld = frm.getField('fld')
fld.removeDesignTimeProperty('myprop')("my_form").getButton("my_button").getUUID();
application.output(button_uuid.toString());
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}