Servoy 2020 Documentation
Child pages
  • JSRecord

Versions Compared

Old Version 7

changes.mady.by.user Paul Bakker

Saved on

compared with

New Version 8

changes.mady.by.user Servoy Docs

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
{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:class=servoy sSummery}{colgroup}{column:width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}MethodProperty Summary{th}{tr}{tbody}{tr}{td}[JSDataSetServoyException]{td}{td}[#getChangedData#exception]\()
Returns last occurred aexception JSDataSeton withthis outstandingrecord (notor saved) changed data of this recordnull).{td}{tr}{tbody}{tbody}{tr}{td}Object[JSFoundset]{td}{td}[#getPKs#foundset]\()
Returns an array with the primary key values parent foundset of the record.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#isEditing]\()
Returns true or false if the record is being edited or not.{td}{tr}{tbody}{table}\\{tabletable}\\ 

{table:class=servoy sDetailsSummery}{colgroup}{column:width=100%80px}{column}{colgroupcolumn}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=12}Method DetailsSummary{th}{tr}{tbody:id=B2C6F5E0-908D-4966-A12D-0C649BD29ADD}{tr:id=name}{td}h6.getChangedData{td}{tr}{tr:id=sig[JSDataSet]{td}{td}{span:style=float: left; margin-right: 5px;}[JSDataSet]{span}{span:id=iets|style=float: left; font-weight: bold;}getChangedData{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:B2C6F5E0-908D-4966-A12D-0C649BD29ADD_des|text=|trigger=button}{sub-section}{sub-section:B2C6F5E0-908D-4966-A12D-0C649BD29ADD_des|trigger=none|class=sIndent}Returns a JSDataSet with outstanding (not saved) changed data of this record.

NOTE: To return an array of records with outstanding changed data, see the function databaseManager.getEditedRecords().{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:B2C6F5E0-908D-4966-A12D-0C649BD29ADD_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:B2C6F5E0-908D-4966-A12D-0C649BD29ADD_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:B2C6F5E0-908D-4966-A12D-0C649BD29ADD_ret[#getChangedData]\()
Returns a JSDataSet with outstanding (not saved) changed data of this record.{td}{tr}{tbody}{tbody}{tr}{td}Object[]{td}{td}[#getPKs]\()
Returns an array with the primary key values of the record.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#isEditing]\()
Returns true or false if the record is being edited or not.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#rollbackChanges]\()
If this record exists in underlying datasource it will do a re-query to fetch the latest data from the datasource.{td}{tr}{tbody}{table}\\ 

{table:class=servoy sDetail}{colgroup}{column:width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Property Details{th}{tr}{tbody:id=A0600588-7B2F-4105-9CF0-AAFC290B36C6}{tr:id=name}{td}h6.exception{td}{tr}{tr:id=des}{td}{sub-section:A0600588-7B2F-4105-9CF0-AAFC290B36C6_des|text=|trigger=button}{sub-section}{sub-section:B2C6F5E0A0600588-908D7B2F-49664105-A12D9CF0-0C649BD29ADDAAFC290B36C6_retdes|trigger=none|class=sIndent}[JSDataSet] -- a JSDataSet with the changed data of this recordReturns last occurred exception on this record (or null).{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:B2C6F5E0A0600588-908D7B2F-49664105-A12D9CF0-0C649BD29ADDAAFC290B36C6_seeprs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:B2C6F5E0A0600588-908D7B2F-49664105-A12D9CF0-0C649BD29ADDAAFC290B36C6_seeprs|class=sIndent|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:B2C6F5E0A0600588-908D7B2F-49664105-A12D9CF0-0C649BD29ADDAAFC290B36C6_seeret|text=|trigger=button}{sub-section}{sub-section:B2C6F5E0A0600588-908D7B2F-49664105-A12D9CF0-0C649BD29ADD_linkAAFC290B36C6_ret|trigger=none|class=sIndent|trigger=none}}[ServoyException] -- The occurred exception.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=samsee}{td}*SampleAlso see*\\{sub-section:B2C6F5E0A0600588-908D7B2F-49664105-A12D9CF0-0C649BD29ADDAAFC290B36C6_samsee|text=|trigger=button}{sub-section}{sub-section:B2C6F5E0A0600588-908D7B2F-49664105-A12D9CF0-0C649BD29ADDAAFC290B36C6_samsee|class=sIndent|trigger=none}{code:language=javascript}
var dataset = record.getChangedData()
for( var i = 1 ; i <= dataset.getMaxRowIndex() ; i++ )
{
	application.output(dataset.getValue(i,1) +' '+ dataset.getValue(i,2) +' '+ dataset.getValue(i,3));
}
{code}}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:A0600588-7B2F-4105-9CF0-AAFC290B36C6_see|text=|trigger=button}{sub-section}{sub-section:A0600588-7B2F-4105-9CF0-AAFC290B36C6_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{tr:class=lastDetailRowbuilder-show}{tr:id=sam}{td}{td}{tr}{tbody}{tbody:id=8E64B3D5-50D4-4A43-B92B-273945E6975F}{tr:id=name}{td}h6.getPKs{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}Object[]{span}{span:id=iets|style=float: left; font-weight: bold;}getPKs{span}{span:id=iets|style=float: left;}\(){span*Sample*\\{sub-section:A0600588-7B2F-4105-9CF0-AAFC290B36C6_sam|text=|trigger=button}{sub-section}{sub-section:A0600588-7B2F-4105-9CF0-AAFC290B36C6_sam|class=sIndent|trigger=none}{code:language=javascript}
var exception = record.exception;
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{trtbody:id=des}{td}{37B2CFB9-3F05-450B-9628-32E374E4D9F4}{tr:id=name}{td}h6.foundset{td}{tr}{tr:id=des}{td}{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_des|text=|trigger=button}{sub-section}{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_des|trigger=none|class=sIndent}Returns an array with the primary key values parent foundset of the record.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_ret|text=|trigger=button}{sub-section}{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_ret|trigger=none|class=sIndent}Object[JSFoundset] -- The anparent Arrayfoundset withof the pk valuesrecord.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_see|text=|trigger=button}{sub-section}{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_see|text=|trigger=button}{sub-section}{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_sam|text=|trigger=button}{sub-section}{sub-section:8E64B3D537B2CFB9-50D43F05-4A43450B-B92B9628-273945E6975F32E374E4D9F4_sam|class=sIndent|trigger=none}{code:language=javascript}
var pksparent = foundset.getSelectedRecord().getPKs() // also foundset.getRecord can be used
{record.foundset;
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=284384E1-67D2-46B2-A828-0FE9FF5F7CBC}{tr:id=name}{td}h6.isEditing{td}{trtable}\\ 

{table:class=servoy sDetail}{colgroup}{column:width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=8F12725E-5EC2-4C6D-B71C-463FCAD13B3F}{tr:id=name}{td}h6.getChangedData{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[BooleanJSDataSet]{span}{span:id=iets|style=float: left; font-weight: bold;}isEditinggetChangedData{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:284384E18F12725E-67D25EC2-46B24C6D-A828B71C-0FE9FF5F7CBC463FCAD13B3F_des|text=|trigger=button}{sub-section}{sub-section:284384E18F12725E-67D25EC2-46B24C6D-A828B71C-0FE9FF5F7CBC463FCAD13B3F_des|trigger=none|class=sIndent}Returns true or false if the record is being edited or not=none|class=sIndent}Returns a JSDataSet with outstanding (not saved) changed data of this record.

NOTE: To return an array of records with outstanding changed data, see the function databaseManager.getEditedRecords().{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:8F12725E-5EC2-4C6D-B71C-463FCAD13B3F_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:8F12725E-5EC2-4C6D-B71C-463FCAD13B3F_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:8F12725E-5EC2-4C6D-B71C-463FCAD13B3F_ret|text=|trigger=button}{sub-section}{sub-section:8F12725E-5EC2-4C6D-B71C-463FCAD13B3F_ret|trigger=none|class=sIndent}[JSDataSet] -- a JSDataSet with the changed data of this record.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:8F12725E-5EC2-4C6D-B71C-463FCAD13B3F_see|text=|trigger=button}{sub-section}{sub-section:8F12725E-5EC2-4C6D-B71C-463FCAD13B3F_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:8F12725E-5EC2-4C6D-B71C-463FCAD13B3F_see|text=|trigger=button}{sub-section}{sub-section:8F12725E-5EC2-4C6D-B71C-463FCAD13B3F_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:8F12725E-5EC2-4C6D-B71C-463FCAD13B3F_sam|text=|trigger=button}{sub-section}{sub-section:8F12725E-5EC2-4C6D-B71C-463FCAD13B3F_sam|class=sIndent|trigger=none}{code:language=javascript}
var dataset = record.getChangedData()
for( var i = 1 ; i <= dataset.getMaxRowIndex() ; i++ )
{
	application.output(dataset.getValue(i,1) +' '+ dataset.getValue(i,2) +' '+ dataset.getValue(i,3));
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=C032134B-A61B-401E-A1A4-649655D22031}{tr:id=name}{td}h6.getPKs{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}Object[]{span}{span:id=iets|style=float: left; font-weight: bold;}getPKs{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:C032134B-A61B-401E-A1A4-649655D22031_des|text=|trigger=button}{sub-section}{sub-section:C032134B-A61B-401E-A1A4-649655D22031_des|trigger=none|class=sIndent}Returns an array with the primary key values of the record.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:C032134B-A61B-401E-A1A4-649655D22031_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C032134B-A61B-401E-A1A4-649655D22031_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:C032134B-A61B-401E-A1A4-649655D22031_ret|text=|trigger=button}{sub-section}{sub-section:C032134B-A61B-401E-A1A4-649655D22031_ret|trigger=none|class=sIndent}Object[] -- an Array with the pk values.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:C032134B-A61B-401E-A1A4-649655D22031_see|text=|trigger=button}{sub-section}{sub-section:C032134B-A61B-401E-A1A4-649655D22031_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:C032134B-A61B-401E-A1A4-649655D22031_see|text=|trigger=button}{sub-section}{sub-section:C032134B-A61B-401E-A1A4-649655D22031_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:C032134B-A61B-401E-A1A4-649655D22031_sam|text=|trigger=button}{sub-section}{sub-section:C032134B-A61B-401E-A1A4-649655D22031_sam|class=sIndent|trigger=none}{code:language=javascript}
var pks = foundset.getSelectedRecord().getPKs() // also foundset.getRecord can be used
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=6AAE8369-09A7-4E7B-85DD-699D7CD825A5}{tr:id=name}{td}h6.isEditing{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}isEditing{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_des|text=|trigger=button}{sub-section}{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_des|trigger=none|class=sIndent}Returns true or false if the record is being edited or not.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_ret|text=|trigger=button}{sub-section}{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_ret|trigger=none|class=sIndent}[Boolean] -- a boolean when in edit.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_see|text=|trigger=button}{sub-section}{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_see|text=|trigger=button}{sub-section}{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_sam|text=|trigger=button}{sub-section}{sub-section:6AAE8369-09A7-4E7B-85DD-699D7CD825A5_sam|class=sIndent|trigger=none}{code:language=javascript}
var isEditing = foundset.getSelectedRecord().isEditing() // also foundset.getRecord can be used
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=69E692E1-35D9-4D61-A6C8-B61BA9C78A8B}{tr:id=name}{td}h6.rollbackChanges{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}rollbackChanges{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:69E692E1-35D9-4D61-A6C8-B61BA9C78A8B_des|text=|trigger=button}{sub-section}{sub-section:69E692E1-35D9-4D61-A6C8-B61BA9C78A8B_des|trigger=none|class=sIndent}If this record exists in underlying datasource it will do a re-query to fetch the latest data from the datasource.
NOTE: If you use transactions then it will be the data of your last update of this record in the transaction,
not the latest committed data of that record in the datasource.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:284384E169E692E1-67D235D9-46B24D61-A828A6C8-0FE9FF5F7CBCB61BA9C78A8B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:284384E169E692E1-67D235D9-46B24D61-A828A6C8-0FE9FF5F7CBCB61BA9C78A8B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:284384E169E692E1-67D235D9-46B24D61-A828A6C8-0FE9FF5F7CBCB61BA9C78A8B_ret|text=|trigger=button}{sub-section}{sub-section:284384E169E692E1-67D235D9-46B24D61-A828A6C8-0FE9FF5F7CBCB61BA9C78A8B_ret|trigger=none|class=sIndent}[Boolean] -- a boolean when in edit.void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:284384E169E692E1-67D235D9-46B24D61-A828A6C8-0FE9FF5F7CBCB61BA9C78A8B_see|text=|trigger=button}{sub-section}{sub-section:284384E169E692E1-67D235D9-46B24D61-A828A6C8-0FE9FF5F7CBCB61BA9C78A8B_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:284384E169E692E1-67D235D9-46B24D61-A828A6C8-0FE9FF5F7CBCB61BA9C78A8B_see|text=|trigger=button}{sub-section}{sub-section:284384E169E692E1-67D235D9-46B24D61-A828A6C8-0FE9FF5F7CBCB61BA9C78A8B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:284384E169E692E1-67D235D9-46B24D61-A828A6C8-0FE9FF5F7CBCB61BA9C78A8B_sam|text=|trigger=button}{sub-section}{sub-section:284384E169E692E1-67D235D9-46B24D61-A828A6C8-0FE9FF5F7CBCB61BA9C78A8B_sam|class=sIndent|trigger=none}{code:language=javascript}
var isEditing record= forms.customer.foundset.getSelectedRecord();
record.isEditingrollbackChanges() // also foundset.getRecord can be used;
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}