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=}A JSFoundset is a scriptable object, it contains record objects defined by its SQL. It does lazy load the PKs and records.
Each foundset has its own record set and selected index{sub-section}\\ 

{table:id=|class=servoy sSummary}{colgroup}{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}[#alldataproviders]
Get all dataproviders of the foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#multiSelect]
Get or set the multiSelect flag of the foundset.{td}{tr}{tbody}{table}\\ 

{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}{tr}{td}[Boolean]{td}{td}[#addFoundSetFilterParam]\(dataprovider, operator, value)
Add a filter parameter that is permanent per user session to limit a specified foundset of records.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#addFoundSetFilterParam]\(dataprovider, operator, value, name)
Add a filter parameter that is permanent per user session to limit a specified foundset of records.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#clear]\()
Clear the foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#deleteAllRecords]\()
Delete all records in foundset, resulting in empty foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#deleteRecord]\()
Delete currently selected record(s).{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#deleteRecord]\(record)
Delete record from foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#deleteRecord]\(index)
Delete record with the given index.{td}{tr}{tbody}{tbody}{tr}{td}[JSFoundSet]{td}{td}[#duplicateFoundSet]\()
Get a duplicate of the foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#duplicateRecord]\()
Duplicate current record, change selection to new record, place on top.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#duplicateRecord]\(onTop)
Duplicate selected record, change selection to new record.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#duplicateRecord]\(onTop, changeSelection)
Duplicate selected record.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#duplicateRecord]\(index)
Duplicate record at index in the foundset, change selection to new record, place on top.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#duplicateRecord]\(index, onTop)
Duplicate record at index in the foundset, change selection to new record.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#duplicateRecord]\(index, onTop, changeSelection)
Duplicate record at index in the foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#duplicateRecord]\(index, location)
Duplicate record at index in the foundset, change selection to new record.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#duplicateRecord]\(index, location, changeSelection)
Duplicate record at index in the foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#find]\()
Set the foundset in find mode.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getCurrentSort]\()
Get the current sort columns.{td}{tr}{tbody}{tbody}{tr}{td}[Object]{td}{td}[#getDataProviderValue]\(dataProviderID)
Get a value based on a dataprovider name.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getDataSource]\()
Get the datasource used.{td}{tr}{tbody}{tbody}{tr}{td}[Object]\[]\[]{td}{td}[#getFoundSetFilterParams]\()
Get the list of previously defined foundset filters.{td}{tr}{tbody}{tbody}{tr}{td}[Object]\[]\[]{td}{td}[#getFoundSetFilterParams]\(filterName)
Get a previously defined foundset filter, using its given name.{td}{tr}{tbody}{tbody}{tr}{td}[QBSelect]{td}{td}[#getQuery]\()
Get the query that the foundset is currently using.{td}{tr}{tbody}{tbody}{tr}{td}[JSRecord]{td}{td}[#getRecord]\(index)
Get the record object at the index.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getRecordIndex]\(record)
Get the record index.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getRelationName]\()
Gets the relation name (null if not a related foundset).{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getSelectedIndex]\()
Get the current record index of the foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Number]\[]{td}{td}[#getSelectedIndexes]\()
Get the indexes of the selected records.{td}{tr}{tbody}{tbody}{tr}{td}[JSRecord]{td}{td}[#getSelectedRecord]\()
Get the selected record.{td}{tr}{tbody}{tbody}{tr}{td}[JSRecord]\[]{td}{td}[#getSelectedRecords]\()
Get the selected records.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getSize]\()
Get the number of records in this foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#hasConditions]\()
Check wether the foundset has any conditions from a previous find action.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#invertRecords]\()
Invert the foundset against all rows of the current table.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#isInFind]\()
Check if this foundset is in find mode.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#loadAllRecords]\()
Loads all accessible records from the datasource into the foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#loadOmittedRecords]\()
Loads the records that are currently omitted as a foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#loadRecords]\()
Reloads all last (related) records again, if, for example, after search in tabpanel.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#loadRecords]\(foundset)
Copies foundset data from another foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#loadRecords]\(dataset)
Loads a primary key dataset, will remove related sort.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#loadRecords]\(querybuilder)
Loads records into form foundset based on a query builder object (also known as 'Form by query').{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#loadRecords]\(uuidpk)
Loads a single record by primary key, will remove related sort.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#loadRecords]\(numberpk)
Loads a single record by primary key, will remove related sort.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#loadRecords]\(queryString)
Loads records into form foundset based on a query (also known as 'Form by query').{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#loadRecords]\(queryString, argumentsArray)
Loads records into form foundset based on a query (also known as 'Form by query').{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#newRecord]\()
Create a new record on top of the foundset and change selection to it.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#newRecord]\(onTop)
Create a new record in the foundset and change selection to it.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#newRecord]\(onTop, changeSelection)
Create a new record in the foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#newRecord]\(index)
Create a new record in the foundset and change selection to it.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#newRecord]\(index, changeSelection)
Create a new record in the foundset.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#omitRecord]\()
Omit current record, to be shown with loadOmittedRecords.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#omitRecord]\(index)
Omit record under the given index, to be shown with loadOmittedRecords.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#relookup]\()
Perform a relookup for the currently selected records
Lookups are defined in the dataprovider (columns) auto\-enter setting and are normally performed over a relation upon record creation.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#relookup]\(index)
Perform a relookup for the record under the given index
Lookups are defined in the dataprovider (columns) auto\-enter setting and are normally performed over a relation upon record creation.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#removeFoundSetFilterParam]\(name)
Remove a named foundset filter.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#search]\()
Start the database search and use the results, returns the number of records, make sure you did "find" function first.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#search]\(clearLastResults)
Start the database search and use the results, returns the number of records, make sure you did "find" function first.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#search]\(clearLastResults, reduceSearch)
Start the database search and use the results, returns the number of records, make sure you did "find" function first.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#selectRecord]\(pkid1, \[pkid2\], \[pkidn\])
Select the record based on pk data.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#setDataProviderValue]\(dataProviderID, value)
Set a value based on a dataprovider name.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#setSelectedIndex]\(index)
Set the current record index.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#setSelectedIndexes]\(indexes)
Set the selected records indexes.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#sort]\(sortString)
Sorts the foundset based on the given sort string.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#sort]\(sortString, defer)
Sorts the foundset based on the given sort string.{td}{tr}{tbody}{tbody}{tr}{td}void{td}{td}[#sort]\(recordComparisonFunction)
Sorts the foundset based on the given record comparator function.{td}{tr}{tbody}{tbody}{tr}{td}[JSFoundSet]{td}{td}[#unrelate]\()
Create a new unrelated foundset that is a copy of the current foundset.{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:id=alldataproviders|class=node}{tr:id=name}{td}h6.alldataproviders{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:alldataproviders_des|trigger=button|text=}{sub-section}{sub-section:alldataproviders_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:alldataproviders_snc|trigger=button|text=}{sub-section}{sub-section:alldataproviders_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:alldataproviders_prs|trigger=button|text=}{sub-section}{sub-section:alldataproviders_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:alldataproviders_ret|trigger=button|text=}{sub-section}{sub-section:alldataproviders_ret|trigger=none|class=sIndent}[String]\[]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:alldataproviders_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:alldataproviders_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:alldataproviders_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:alldataproviders_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:alldataproviders_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:alldataproviders_sam|trigger=none}{code:language=javascript}
var dataprovidersNames = forms.customer.alldataproviders;
application.output("This foundset has " + dataprovidersNames.length + " data providers.")
for (var i=0; i<dataprovidersNames.length; i++)
	application.output(dataprovidersNames[i]);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=multiSelect|class=node}{tr:id=name}{td}h6.multiSelect{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:multiSelect_des|trigger=button|text=}{sub-section}{sub-section:multiSelect_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:multiSelect_snc|trigger=button|text=}{sub-section}{sub-section:multiSelect_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:multiSelect_prs|trigger=button|text=}{sub-section}{sub-section:multiSelect_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:multiSelect_ret|trigger=button|text=}{sub-section}{sub-section:multiSelect_ret|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:multiSelect_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiSelect_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:multiSelect_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiSelect_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:multiSelect_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiSelect_sam|trigger=none}{code:language=javascript}
// allow user to select multiple rows.
forms.customer.foundset.multiSelect = true;
{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=addFoundSetFilterParam-String_String_Object|class=node}{tr:id=name}{td}h6.addFoundSetFilterParam{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}addFoundSetFilterParam{span}{span:id=iets|style=float: left;}\(dataprovider, operator, value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:addFoundSetFilterParam-String_String_Object_des|trigger=button|text=}{sub-section}{sub-section:addFoundSetFilterParam-String_String_Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:addFoundSetFilterParam-String_String_Object_snc|trigger=button|text=}{sub-section}{sub-section:addFoundSetFilterParam-String_String_Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:addFoundSetFilterParam-String_String_Object_prs|trigger=button|text=}{sub-section}{sub-section:addFoundSetFilterParam-String_String_Object_prs|trigger=none|class=sIndent}\{[String]} dataprovider -- String column to filter on.
\{[String]} operator -- String operator: =, <, >, >=, <=, !=, (NOT) LIKE, (NOT) IN, (NOT) BETWEEN and IS (NOT) NULL optionally augmented with modifiers "#" (ignore case) or "^||" (or\-is\-null).
\{[Object]} value -- Object filter value (for in array and between an array with 2 elements)
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:addFoundSetFilterParam-String_String_Object_ret|trigger=button|text=}{sub-section}{sub-section:addFoundSetFilterParam-String_String_Object_ret|trigger=none|class=sIndent}[Boolean] -- true if adding the filter succeeded, false otherwise.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:addFoundSetFilterParam-String_String_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addFoundSetFilterParam-String_String_Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:addFoundSetFilterParam-String_String_Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addFoundSetFilterParam-String_String_Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:addFoundSetFilterParam-String_String_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addFoundSetFilterParam-String_String_Object_sam|trigger=none}{code:language=javascript}
// Filter a fondset on a dataprovider value.
// Note that multiple filters can be added to the same dataprovider, they will all be applied.

var success = forms.customer.foundset.addFoundSetFilterParam('customerid', '=', 'BLONP', 'custFilter');//possible to add multiple
forms.customer.foundset.loadAllRecords();//to make param(s) effective
// Named filters can be removed using forms.customer.foundset.removeFoundSetFilterParam(filterName)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=addFoundSetFilterParam-String_String_Object_String|class=node}{tr:id=name}{td}h6.addFoundSetFilterParam{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}addFoundSetFilterParam{span}{span:id=iets|style=float: left;}\(dataprovider, operator, value, name){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:addFoundSetFilterParam-String_String_Object_String_des|trigger=button|text=}{sub-section}{sub-section:addFoundSetFilterParam-String_String_Object_String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:addFoundSetFilterParam-String_String_Object_String_snc|trigger=button|text=}{sub-section}{sub-section:addFoundSetFilterParam-String_String_Object_String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:addFoundSetFilterParam-String_String_Object_String_prs|trigger=button|text=}{sub-section}{sub-section:addFoundSetFilterParam-String_String_Object_String_prs|trigger=none|class=sIndent}\{[String]} dataprovider -- String column to filter on.
\{[String]} operator -- String operator: =, <, >, >=, <=, !=, (NOT) LIKE, (NOT) IN, (NOT) BETWEEN and IS (NOT) NULL optionally augmented with modifiers "#" (ignore case) or "^||" (or\-is\-null).
\{[Object]} value -- Object filter value (for in array and between an array with 2 elements)
\{[String]} name -- String name, used to remove the filter again.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:addFoundSetFilterParam-String_String_Object_String_ret|trigger=button|text=}{sub-section}{sub-section:addFoundSetFilterParam-String_String_Object_String_ret|trigger=none|class=sIndent}[Boolean] -- true if adding the filter succeeded, false otherwise.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:addFoundSetFilterParam-String_String_Object_String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addFoundSetFilterParam-String_String_Object_String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:addFoundSetFilterParam-String_String_Object_String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addFoundSetFilterParam-String_String_Object_String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:addFoundSetFilterParam-String_String_Object_String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addFoundSetFilterParam-String_String_Object_String_sam|trigger=none}{code:language=javascript}
var success = forms.customer.foundset.addFoundSetFilterParam('customerid', '=', 'BLONP', 'custFilter');//possible to add multiple
// Named filters can be removed using forms.customer.foundset.removeFoundSetFilterParam(filterName)

// you can use modifiers in the operator as well, filter on companies where companyname is null or equals-ignore-case 'servoy'
var ok = forms.customer.foundset.addFoundSetFilterParam('companyname', '#^||=', 'servoy')

forms.customer.foundset.loadAllRecords();//to make param(s) effective
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=clear|class=node}{tr:id=name}{td}h6.clear{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}clear{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:clear_des|trigger=button|text=}{sub-section}{sub-section:clear_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:clear_snc|trigger=button|text=}{sub-section}{sub-section:clear_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:clear_prs|trigger=button|text=}{sub-section}{sub-section:clear_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:clear_ret|trigger=button|text=}{sub-section}{sub-section:clear_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:clear_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:clear_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:clear_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:clear_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:clear_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:clear_sam|trigger=none}{code:language=javascript}
//Clear the foundset, including searches that may be on it
forms.customer.foundset.clear();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=deleteAllRecords|class=node}{tr:id=name}{td}h6.deleteAllRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}deleteAllRecords{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:deleteAllRecords_des|trigger=button|text=}{sub-section}{sub-section:deleteAllRecords_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:deleteAllRecords_snc|trigger=button|text=}{sub-section}{sub-section:deleteAllRecords_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:deleteAllRecords_prs|trigger=button|text=}{sub-section}{sub-section:deleteAllRecords_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:deleteAllRecords_ret|trigger=button|text=}{sub-section}{sub-section:deleteAllRecords_ret|trigger=none|class=sIndent}[Boolean] -- boolean true if all records could be deleted.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:deleteAllRecords_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteAllRecords_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:deleteAllRecords_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteAllRecords_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:deleteAllRecords_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteAllRecords_sam|trigger=none}{code:language=javascript}
var success = forms.customer.foundset.deleteAllRecords();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=deleteRecord|class=node}{tr:id=name}{td}h6.deleteRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}deleteRecord{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:deleteRecord_des|trigger=button|text=}{sub-section}{sub-section:deleteRecord_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:deleteRecord_snc|trigger=button|text=}{sub-section}{sub-section:deleteRecord_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:deleteRecord_prs|trigger=button|text=}{sub-section}{sub-section:deleteRecord_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:deleteRecord_ret|trigger=button|text=}{sub-section}{sub-section:deleteRecord_ret|trigger=none|class=sIndent}[Boolean] -- boolean true if all records could be deleted.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:deleteRecord_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteRecord_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:deleteRecord_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteRecord_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:deleteRecord_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteRecord_sam|trigger=none}{code:language=javascript}
var success = forms.customer.foundset.deleteRecord();
//can return false incase of related foundset having records and orphans records are not allowed by the relation
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=deleteRecord-JSRecord|class=node}{tr:id=name}{td}h6.deleteRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}deleteRecord{span}{span:id=iets|style=float: left;}\(record){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:deleteRecord-JSRecord_des|trigger=button|text=}{sub-section}{sub-section:deleteRecord-JSRecord_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:deleteRecord-JSRecord_snc|trigger=button|text=}{sub-section}{sub-section:deleteRecord-JSRecord_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:deleteRecord-JSRecord_prs|trigger=button|text=}{sub-section}{sub-section:deleteRecord-JSRecord_prs|trigger=none|class=sIndent}\{[JSRecord]} record -- The record to delete from the foundset.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:deleteRecord-JSRecord_ret|trigger=button|text=}{sub-section}{sub-section:deleteRecord-JSRecord_ret|trigger=none|class=sIndent}[Boolean] -- boolean true if record could be deleted.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:deleteRecord-JSRecord_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteRecord-JSRecord_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:deleteRecord-JSRecord_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteRecord-JSRecord_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:deleteRecord-JSRecord_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteRecord-JSRecord_sam|trigger=none}{code:language=javascript}
var success = forms.customer.foundset.deleteRecord(rec);
//can return false incase of related foundset having records and orphans records are not allowed by the relation
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=deleteRecord-Number|class=node}{tr:id=name}{td}h6.deleteRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}deleteRecord{span}{span:id=iets|style=float: left;}\(index){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:deleteRecord-Number_des|trigger=button|text=}{sub-section}{sub-section:deleteRecord-Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:deleteRecord-Number_snc|trigger=button|text=}{sub-section}{sub-section:deleteRecord-Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:deleteRecord-Number_prs|trigger=button|text=}{sub-section}{sub-section:deleteRecord-Number_prs|trigger=none|class=sIndent}\{[Number]} index -- The index of the record to delete.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:deleteRecord-Number_ret|trigger=button|text=}{sub-section}{sub-section:deleteRecord-Number_ret|trigger=none|class=sIndent}[Boolean] -- boolean true if record could be deleted.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:deleteRecord-Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteRecord-Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:deleteRecord-Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteRecord-Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:deleteRecord-Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:deleteRecord-Number_sam|trigger=none}{code:language=javascript}
var success = forms.customer.foundset.deleteRecord(4);
//can return false incase of related foundset having records and orphans records are not allowed by the relation
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=duplicateFoundSet|class=node}{tr:id=name}{td}h6.duplicateFoundSet{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[JSFoundSet]{span}{span:id=iets|style=float: left; font-weight: bold;}duplicateFoundSet{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:duplicateFoundSet_des|trigger=button|text=}{sub-section}{sub-section:duplicateFoundSet_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:duplicateFoundSet_snc|trigger=button|text=}{sub-section}{sub-section:duplicateFoundSet_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:duplicateFoundSet_prs|trigger=button|text=}{sub-section}{sub-section:duplicateFoundSet_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:duplicateFoundSet_ret|trigger=button|text=}{sub-section}{sub-section:duplicateFoundSet_ret|trigger=none|class=sIndent}[JSFoundSet] -- foundset duplicate.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:duplicateFoundSet_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateFoundSet_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:duplicateFoundSet_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateFoundSet_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:duplicateFoundSet_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateFoundSet_sam|trigger=none}{code:language=javascript}
var dupFoundset = forms.customer.foundset.duplicateFoundSet();
forms.customer.foundset.find();
//search some fields
var count = forms.customer.foundset.search();
if (count == 0)
{
	plugins.dialogs.showWarningDialog('Alert', 'No records found','OK');
	forms.customer.foundset.loadRecords(dupFoundset);
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=duplicateRecord|class=node}{tr:id=name}{td}h6.duplicateRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}duplicateRecord{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:duplicateRecord_des|trigger=button|text=}{sub-section}{sub-section:duplicateRecord_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:duplicateRecord_snc|trigger=button|text=}{sub-section}{sub-section:duplicateRecord_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:duplicateRecord_prs|trigger=button|text=}{sub-section}{sub-section:duplicateRecord_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:duplicateRecord_ret|trigger=button|text=}{sub-section}{sub-section:duplicateRecord_ret|trigger=none|class=sIndent}[Number] -- 0 if record was not created or the record index if it was created.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:duplicateRecord_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:duplicateRecord_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:duplicateRecord_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.duplicateRecord();
forms.customer.foundset.duplicateRecord(false); //duplicate the current record, adds at bottom
forms.customer.foundset.duplicateRecord(1,2); //duplicate the first record as second record
//duplicates the record (record index 3), adds on top and selects the record
forms.customer.foundset.duplicateRecord(3,true,true);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=duplicateRecord-Boolean|class=node}{tr:id=name}{td}h6.duplicateRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}duplicateRecord{span}{span:id=iets|style=float: left;}\(onTop){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:duplicateRecord-Boolean_des|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:duplicateRecord-Boolean_snc|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:duplicateRecord-Boolean_prs|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Boolean_prs|trigger=none|class=sIndent}\{[Boolean]} onTop -- when true the new record is added as the topmost record.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:duplicateRecord-Boolean_ret|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Boolean_ret|trigger=none|class=sIndent}[Number] -- 0 if record was not created or the record index if it was created.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:duplicateRecord-Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:duplicateRecord-Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:duplicateRecord-Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Boolean_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.duplicateRecord();
forms.customer.foundset.duplicateRecord(false); //duplicate the current record, adds at bottom
forms.customer.foundset.duplicateRecord(1,2); //duplicate the first record as second record
//duplicates the record (record index 3), adds on top and selects the record
forms.customer.foundset.duplicateRecord(3,true,true);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=duplicateRecord-Boolean_Boolean|class=node}{tr:id=name}{td}h6.duplicateRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}duplicateRecord{span}{span:id=iets|style=float: left;}\(onTop, changeSelection){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:duplicateRecord-Boolean_Boolean_des|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Boolean_Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:duplicateRecord-Boolean_Boolean_snc|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Boolean_Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:duplicateRecord-Boolean_Boolean_prs|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Boolean_Boolean_prs|trigger=none|class=sIndent}\{[Boolean]} onTop -- when true the new record is added as the topmost record.
\{[Boolean]} changeSelection -- when true the selection is changed to the duplicated record.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:duplicateRecord-Boolean_Boolean_ret|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Boolean_Boolean_ret|trigger=none|class=sIndent}[Number] -- 0 if record was not created or the record index if it was created.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:duplicateRecord-Boolean_Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Boolean_Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:duplicateRecord-Boolean_Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Boolean_Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:duplicateRecord-Boolean_Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Boolean_Boolean_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.duplicateRecord();
forms.customer.foundset.duplicateRecord(false); //duplicate the current record, adds at bottom
forms.customer.foundset.duplicateRecord(1,2); //duplicate the first record as second record
//duplicates the record (record index 3), adds on top and selects the record
forms.customer.foundset.duplicateRecord(3,true,true);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=duplicateRecord-Number|class=node}{tr:id=name}{td}h6.duplicateRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}duplicateRecord{span}{span:id=iets|style=float: left;}\(index){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:duplicateRecord-Number_des|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:duplicateRecord-Number_snc|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:duplicateRecord-Number_prs|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_prs|trigger=none|class=sIndent}\{[Number]} index -- The index of the record to duplicate; defaults to currently selected index. Ignored if first given parameter is a boolean value.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:duplicateRecord-Number_ret|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_ret|trigger=none|class=sIndent}[Number] -- 0 if record was not created or the record index if it was created.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:duplicateRecord-Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:duplicateRecord-Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:duplicateRecord-Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.duplicateRecord();
forms.customer.foundset.duplicateRecord(false); //duplicate the current record, adds at bottom
forms.customer.foundset.duplicateRecord(1,2); //duplicate the first record as second record
//duplicates the record (record index 3), adds on top and selects the record
forms.customer.foundset.duplicateRecord(3,true,true);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=duplicateRecord-Number_Boolean|class=node}{tr:id=name}{td}h6.duplicateRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}duplicateRecord{span}{span:id=iets|style=float: left;}\(index, onTop){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:duplicateRecord-Number_Boolean_des|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:duplicateRecord-Number_Boolean_snc|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:duplicateRecord-Number_Boolean_prs|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Boolean_prs|trigger=none|class=sIndent}\{[Number]} index -- The index of the record to duplicate; defaults to currently selected index. Ignored if first given parameter is a boolean value.
\{[Boolean]} onTop -- when true the new record is added as the topmost record.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:duplicateRecord-Number_Boolean_ret|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Boolean_ret|trigger=none|class=sIndent}[Number] -- 0 if record was not created or the record index if it was created.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:duplicateRecord-Number_Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:duplicateRecord-Number_Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:duplicateRecord-Number_Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Boolean_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.duplicateRecord();
forms.customer.foundset.duplicateRecord(false); //duplicate the current record, adds at bottom
forms.customer.foundset.duplicateRecord(1,2); //duplicate the first record as second record
//duplicates the record (record index 3), adds on top and selects the record
forms.customer.foundset.duplicateRecord(3,true,true);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=duplicateRecord-Number_Boolean_Boolean|class=node}{tr:id=name}{td}h6.duplicateRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}duplicateRecord{span}{span:id=iets|style=float: left;}\(index, onTop, changeSelection){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:duplicateRecord-Number_Boolean_Boolean_des|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Boolean_Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:duplicateRecord-Number_Boolean_Boolean_snc|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Boolean_Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:duplicateRecord-Number_Boolean_Boolean_prs|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Boolean_Boolean_prs|trigger=none|class=sIndent}\{[Number]} index -- The index of the record to duplicate; defaults to currently selected index. Ignored if first given parameter is a boolean value.
\{[Boolean]} onTop -- when true the new record is added as the topmost record.
\{[Boolean]} changeSelection -- when true the selection is changed to the duplicated record.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:duplicateRecord-Number_Boolean_Boolean_ret|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Boolean_Boolean_ret|trigger=none|class=sIndent}[Number] -- 0 if record was not created or the record index if it was created.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:duplicateRecord-Number_Boolean_Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Boolean_Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:duplicateRecord-Number_Boolean_Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Boolean_Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:duplicateRecord-Number_Boolean_Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Boolean_Boolean_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.duplicateRecord();
forms.customer.foundset.duplicateRecord(false); //duplicate the current record, adds at bottom
forms.customer.foundset.duplicateRecord(1,2); //duplicate the first record as second record
//duplicates the record (record index 3), adds on top and selects the record
forms.customer.foundset.duplicateRecord(3,true,true);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=duplicateRecord-Number_Number|class=node}{tr:id=name}{td}h6.duplicateRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}duplicateRecord{span}{span:id=iets|style=float: left;}\(index, location){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:duplicateRecord-Number_Number_des|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:duplicateRecord-Number_Number_snc|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:duplicateRecord-Number_Number_prs|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Number_prs|trigger=none|class=sIndent}\{[Number]} index -- The index of the record to duplicate; defaults to currently selected index. Ignored if first given parameter is a boolean value.
\{[Number]} location -- the new record is added at specified index
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:duplicateRecord-Number_Number_ret|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Number_ret|trigger=none|class=sIndent}[Number] -- 0 if record was not created or the record index if it was created.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:duplicateRecord-Number_Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:duplicateRecord-Number_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:duplicateRecord-Number_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Number_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.duplicateRecord();
forms.customer.foundset.duplicateRecord(false); //duplicate the current record, adds at bottom
forms.customer.foundset.duplicateRecord(1,2); //duplicate the first record as second record
//duplicates the record (record index 3), adds on top and selects the record
forms.customer.foundset.duplicateRecord(3,true,true);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=duplicateRecord-Number_Number_Boolean|class=node}{tr:id=name}{td}h6.duplicateRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}duplicateRecord{span}{span:id=iets|style=float: left;}\(index, location, changeSelection){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:duplicateRecord-Number_Number_Boolean_des|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Number_Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:duplicateRecord-Number_Number_Boolean_snc|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Number_Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:duplicateRecord-Number_Number_Boolean_prs|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Number_Boolean_prs|trigger=none|class=sIndent}\{[Number]} index -- The index of the record to duplicate; defaults to currently selected index. Ignored if first given parameter is a boolean value.
\{[Number]} location -- the new record is added at specified index
\{[Boolean]} changeSelection -- when true the selection is changed to the duplicated record.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:duplicateRecord-Number_Number_Boolean_ret|trigger=button|text=}{sub-section}{sub-section:duplicateRecord-Number_Number_Boolean_ret|trigger=none|class=sIndent}[Number] -- 0 if record was not created or the record index if it was created.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:duplicateRecord-Number_Number_Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Number_Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:duplicateRecord-Number_Number_Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Number_Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:duplicateRecord-Number_Number_Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:duplicateRecord-Number_Number_Boolean_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.duplicateRecord();
forms.customer.foundset.duplicateRecord(false); //duplicate the current record, adds at bottom
forms.customer.foundset.duplicateRecord(1,2); //duplicate the first record as second record
//duplicates the record (record index 3), adds on top and selects the record
forms.customer.foundset.duplicateRecord(3,true,true);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=find|class=node}{tr:id=name}{td}h6.find{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}find{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:find_des|trigger=button|text=}{sub-section}{sub-section:find_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:find_snc|trigger=button|text=}{sub-section}{sub-section:find_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:find_prs|trigger=button|text=}{sub-section}{sub-section:find_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:find_ret|trigger=button|text=}{sub-section}{sub-section:find_ret|trigger=none|class=sIndent}[Boolean] -- true if the foundset is now in find mode, false otherwise.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:find_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:find_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:find_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:find_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:find_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:find_sam|trigger=none}{code:language=javascript}
if (forms.customer.foundset.find()) //find will fail if autosave is disabled and there are unsaved records
{
	columnTextDataProvider = 'a search value'
	// for numbers you have to make sure to format it correctly so that the decimal point is in your locales notation (. or ,)
	columnNumberDataProvider = '>' + utils.numberFormat(anumber, '####.00');
	columnDateDataProvider = '31-12-2010|dd-MM-yyyy'
	forms.customer.foundset.search()
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getCurrentSort|class=node}{tr:id=name}{td}h6.getCurrentSort{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getCurrentSort{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getCurrentSort_des|trigger=button|text=}{sub-section}{sub-section:getCurrentSort_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getCurrentSort_snc|trigger=button|text=}{sub-section}{sub-section:getCurrentSort_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:getCurrentSort_prs|trigger=button|text=}{sub-section}{sub-section:getCurrentSort_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getCurrentSort_ret|trigger=button|text=}{sub-section}{sub-section:getCurrentSort_ret|trigger=none|class=sIndent}[String] -- String sort columns{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getCurrentSort_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getCurrentSort_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getCurrentSort_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getCurrentSort_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getCurrentSort_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getCurrentSort_sam|trigger=none}{code:language=javascript}
//reverse the current sort

//the original sort "companyName asc, companyContact desc"
//the inversed sort "companyName desc, companyContact asc"
var foundsetSort = foundset.getCurrentSort()
var sortColumns = foundsetSort.split(',')
var newFoundsetSort = ''
for(var i=0; i<sortColumns.length; i++)
{
	var currentSort = sortColumns[i]
	var sortType = currentSort.substring(currentSort.length-3)
	if(sortType.equalsIgnoreCase('asc'))
	{
		newFoundsetSort += currentSort.replace(' asc', ' desc')
	}
	else
	{
		newFoundsetSort += currentSort.replace(' desc', ' asc')
	}
	if(i != sortColumns.length - 1)
	{
		newFoundsetSort += ','
	}
}
foundset.sort(newFoundsetSort)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getDataProviderValue-String|class=node}{tr:id=name}{td}h6.getDataProviderValue{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Object]{span}{span:id=iets|style=float: left; font-weight: bold;}getDataProviderValue{span}{span:id=iets|style=float: left;}\(dataProviderID){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getDataProviderValue-String_des|trigger=button|text=}{sub-section}{sub-section:getDataProviderValue-String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getDataProviderValue-String_snc|trigger=button|text=}{sub-section}{sub-section:getDataProviderValue-String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:getDataProviderValue-String_prs|trigger=button|text=}{sub-section}{sub-section:getDataProviderValue-String_prs|trigger=none|class=sIndent}\{[String]} dataProviderID -- data provider name
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:getDataProviderValue-String_ret|trigger=button|text=}{sub-section}{sub-section:getDataProviderValue-String_ret|trigger=none|class=sIndent}[Object] -- Object value{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getDataProviderValue-String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getDataProviderValue-String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getDataProviderValue-String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getDataProviderValue-String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getDataProviderValue-String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getDataProviderValue-String_sam|trigger=none}{code:language=javascript}
var val = forms.customer.foundset.getDataProviderValue('contact_name');
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getDataSource|class=node}{tr:id=name}{td}h6.getDataSource{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getDataSource{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getDataSource_des|trigger=button|text=}{sub-section}{sub-section:getDataSource_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getDataSource_snc|trigger=button|text=}{sub-section}{sub-section:getDataSource_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:getDataSource_prs|trigger=button|text=}{sub-section}{sub-section:getDataSource_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getDataSource_ret|trigger=button|text=}{sub-section}{sub-section:getDataSource_ret|trigger=none|class=sIndent}[String] -- String data source.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getDataSource_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getDataSource_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getDataSource_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getDataSource_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getDataSource_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getDataSource_sam|trigger=none}{code:language=javascript}
var dataSource = forms.customer.foundset.getDataSource();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getFoundSetFilterParams|class=node}{tr:id=name}{td}h6.getFoundSetFilterParams{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Object]\[]\[]{span}{span:id=iets|style=float: left; font-weight: bold;}getFoundSetFilterParams{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getFoundSetFilterParams_des|trigger=button|text=}{sub-section}{sub-section:getFoundSetFilterParams_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getFoundSetFilterParams_snc|trigger=button|text=}{sub-section}{sub-section:getFoundSetFilterParams_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:getFoundSetFilterParams_prs|trigger=button|text=}{sub-section}{sub-section:getFoundSetFilterParams_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getFoundSetFilterParams_ret|trigger=button|text=}{sub-section}{sub-section:getFoundSetFilterParams_ret|trigger=none|class=sIndent}[Object]\[]\[] -- Array of filter definitions.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getFoundSetFilterParams_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getFoundSetFilterParams_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getFoundSetFilterParams_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getFoundSetFilterParams_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getFoundSetFilterParams_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getFoundSetFilterParams_sam|trigger=none}{code:language=javascript}
var params = foundset.getFoundSetFilterParams()
for (var i = 0; params != null && i < params.length; i++)
{
	application.output('FoundSet filter on table ' + params[i][0]+ ': '+ params[i][1]+ ' '+params[i][2]+ ' '+params[i][3] +(params[i][4] == null ? ' [no name]' : ' ['+params[i][4]+']'))
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getFoundSetFilterParams-String|class=node}{tr:id=name}{td}h6.getFoundSetFilterParams{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Object]\[]\[]{span}{span:id=iets|style=float: left; font-weight: bold;}getFoundSetFilterParams{span}{span:id=iets|style=float: left;}\(filterName){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getFoundSetFilterParams-String_des|trigger=button|text=}{sub-section}{sub-section:getFoundSetFilterParams-String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getFoundSetFilterParams-String_snc|trigger=button|text=}{sub-section}{sub-section:getFoundSetFilterParams-String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:getFoundSetFilterParams-String_prs|trigger=button|text=}{sub-section}{sub-section:getFoundSetFilterParams-String_prs|trigger=none|class=sIndent}\{[String]} filterName -- name of the filter to retrieve.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:getFoundSetFilterParams-String_ret|trigger=button|text=}{sub-section}{sub-section:getFoundSetFilterParams-String_ret|trigger=none|class=sIndent}[Object]\[]\[] -- Array of filter definitions.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getFoundSetFilterParams-String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getFoundSetFilterParams-String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getFoundSetFilterParams-String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getFoundSetFilterParams-String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getFoundSetFilterParams-String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getFoundSetFilterParams-String_sam|trigger=none}{code:language=javascript}
var params = foundset.getFoundSetFilterParams()
for (var i = 0; params != null && i < params.length; i++)
{
	application.output('FoundSet filter on table ' + params[i][0]+ ': '+ params[i][1]+ ' '+params[i][2]+ ' '+params[i][3] +(params[i][4] == null ? ' [no name]' : ' ['+params[i][4]+']'))
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getQuery|class=node}{tr:id=name}{td}h6.getQuery{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBSelect]{span}{span:id=iets|style=float: left; font-weight: bold;}getQuery{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getQuery_des|trigger=button|text=}{sub-section}{sub-section:getQuery_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getQuery_snc|trigger=button|text=}{sub-section}{sub-section:getQuery_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:getQuery_prs|trigger=button|text=}{sub-section}{sub-section:getQuery_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getQuery_ret|trigger=button|text=}{sub-section}{sub-section:getQuery_ret|trigger=none|class=sIndent}[QBSelect] -- query.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getQuery_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getQuery_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getQuery_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getQuery_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getQuery_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getQuery_sam|trigger=none}{code:language=javascript}
var q = foundset.getQuery()
q.where.add(q.columns.x.eq(100))
foundset.loadRecords(q);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getRecord-Number|class=node}{tr:id=name}{td}h6.getRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[JSRecord]{span}{span:id=iets|style=float: left; font-weight: bold;}getRecord{span}{span:id=iets|style=float: left;}\(index){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getRecord-Number_des|trigger=button|text=}{sub-section}{sub-section:getRecord-Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getRecord-Number_snc|trigger=button|text=}{sub-section}{sub-section:getRecord-Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:getRecord-Number_prs|trigger=button|text=}{sub-section}{sub-section:getRecord-Number_prs|trigger=none|class=sIndent}\{[Number]} index -- record index
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:getRecord-Number_ret|trigger=button|text=}{sub-section}{sub-section:getRecord-Number_ret|trigger=none|class=sIndent}[JSRecord] -- Record record.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getRecord-Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getRecord-Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getRecord-Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getRecord-Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getRecord-Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getRecord-Number_sam|trigger=none}{code:language=javascript}
var record = forms.customer.foundset.getRecord(index);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getRecordIndex-JSRecord|class=node}{tr:id=name}{td}h6.getRecordIndex{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}getRecordIndex{span}{span:id=iets|style=float: left;}\(record){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getRecordIndex-JSRecord_des|trigger=button|text=}{sub-section}{sub-section:getRecordIndex-JSRecord_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getRecordIndex-JSRecord_snc|trigger=button|text=}{sub-section}{sub-section:getRecordIndex-JSRecord_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:getRecordIndex-JSRecord_prs|trigger=button|text=}{sub-section}{sub-section:getRecordIndex-JSRecord_prs|trigger=none|class=sIndent}\{[JSRecord]} record -- Record
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:getRecordIndex-JSRecord_ret|trigger=button|text=}{sub-section}{sub-section:getRecordIndex-JSRecord_ret|trigger=none|class=sIndent}[Number] -- int index.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getRecordIndex-JSRecord_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getRecordIndex-JSRecord_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getRecordIndex-JSRecord_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getRecordIndex-JSRecord_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getRecordIndex-JSRecord_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getRecordIndex-JSRecord_sam|trigger=none}{code:language=javascript}
var index = forms.customer.foundset.getRecordIndex(record);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getRelationName|class=node}{tr:id=name}{td}h6.getRelationName{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getRelationName{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getRelationName_des|trigger=button|text=}{sub-section}{sub-section:getRelationName_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getRelationName_snc|trigger=button|text=}{sub-section}{sub-section:getRelationName_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:getRelationName_prs|trigger=button|text=}{sub-section}{sub-section:getRelationName_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getRelationName_ret|trigger=button|text=}{sub-section}{sub-section:getRelationName_ret|trigger=none|class=sIndent}[String] -- String relation name when related.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getRelationName_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getRelationName_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getRelationName_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getRelationName_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getRelationName_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getRelationName_sam|trigger=none}{code:language=javascript}
var relName = forms.customer.foundset.getRelationName();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getSelectedIndex|class=node}{tr:id=name}{td}h6.getSelectedIndex{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}getSelectedIndex{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getSelectedIndex_des|trigger=button|text=}{sub-section}{sub-section:getSelectedIndex_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getSelectedIndex_snc|trigger=button|text=}{sub-section}{sub-section:getSelectedIndex_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:getSelectedIndex_prs|trigger=button|text=}{sub-section}{sub-section:getSelectedIndex_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getSelectedIndex_ret|trigger=button|text=}{sub-section}{sub-section:getSelectedIndex_ret|trigger=none|class=sIndent}[Number] -- int current index (1-based){sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getSelectedIndex_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedIndex_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getSelectedIndex_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedIndex_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getSelectedIndex_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedIndex_sam|trigger=none}{code:language=javascript}
//gets the current record index in the current foundset
var current = forms.customer.foundset.getSelectedIndex();
//sets the next record in the foundset
forms.customer.foundset.setSelectedIndex(current+1);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getSelectedIndexes|class=node}{tr:id=name}{td}h6.getSelectedIndexes{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]\[]{span}{span:id=iets|style=float: left; font-weight: bold;}getSelectedIndexes{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getSelectedIndexes_des|trigger=button|text=}{sub-section}{sub-section:getSelectedIndexes_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getSelectedIndexes_snc|trigger=button|text=}{sub-section}{sub-section:getSelectedIndexes_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:getSelectedIndexes_prs|trigger=button|text=}{sub-section}{sub-section:getSelectedIndexes_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getSelectedIndexes_ret|trigger=button|text=}{sub-section}{sub-section:getSelectedIndexes_ret|trigger=none|class=sIndent}[Number]\[] -- Array current indexes (1-based){sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getSelectedIndexes_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedIndexes_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getSelectedIndexes_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedIndexes_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getSelectedIndexes_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedIndexes_sam|trigger=none}{code:language=javascript}
// modify selection to the first selected item and the following row only
var current = forms.customer.foundset.getSelectedIndexes();
if (current.length > 1)
{
	var newSelection = new Array();
	newSelection[0] = current[0]; // first current selection
	newSelection[1] = current[0] + 1; // and the next row
	forms.customer.foundset.setSelectedIndexes(newSelection);
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getSelectedRecord|class=node}{tr:id=name}{td}h6.getSelectedRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[JSRecord]{span}{span:id=iets|style=float: left; font-weight: bold;}getSelectedRecord{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getSelectedRecord_des|trigger=button|text=}{sub-section}{sub-section:getSelectedRecord_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getSelectedRecord_snc|trigger=button|text=}{sub-section}{sub-section:getSelectedRecord_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:getSelectedRecord_prs|trigger=button|text=}{sub-section}{sub-section:getSelectedRecord_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getSelectedRecord_ret|trigger=button|text=}{sub-section}{sub-section:getSelectedRecord_ret|trigger=none|class=sIndent}[JSRecord] -- Record record.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getSelectedRecord_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedRecord_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getSelectedRecord_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedRecord_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getSelectedRecord_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedRecord_sam|trigger=none}{code:language=javascript}
var selectedRecord = forms.customer.foundset.getSelectedRecord();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getSelectedRecords|class=node}{tr:id=name}{td}h6.getSelectedRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[JSRecord]\[]{span}{span:id=iets|style=float: left; font-weight: bold;}getSelectedRecords{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getSelectedRecords_des|trigger=button|text=}{sub-section}{sub-section:getSelectedRecords_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getSelectedRecords_snc|trigger=button|text=}{sub-section}{sub-section:getSelectedRecords_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:getSelectedRecords_prs|trigger=button|text=}{sub-section}{sub-section:getSelectedRecords_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getSelectedRecords_ret|trigger=button|text=}{sub-section}{sub-section:getSelectedRecords_ret|trigger=none|class=sIndent}[JSRecord]\[] -- Array current records.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getSelectedRecords_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedRecords_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getSelectedRecords_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedRecords_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getSelectedRecords_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSelectedRecords_sam|trigger=none}{code:language=javascript}
var selectedRecords = forms.customer.foundset.getSelectedRecords();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getSize|class=node}{tr:id=name}{td}h6.getSize{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}getSize{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getSize_des|trigger=button|text=}{sub-section}{sub-section:getSize_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getSize_snc|trigger=button|text=}{sub-section}{sub-section:getSize_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:getSize_prs|trigger=button|text=}{sub-section}{sub-section:getSize_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getSize_ret|trigger=button|text=}{sub-section}{sub-section:getSize_ret|trigger=none|class=sIndent}[Number] -- int current size.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getSize_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSize_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getSize_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSize_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getSize_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getSize_sam|trigger=none}{code:language=javascript}
var nrRecords = forms.customer.foundset.getSize()

// to loop over foundset, recalculate size for each record
for (var i = 1; i <= forms.customer.foundset.getSize(); i++)
{
	var rec = forms.customer.foundset.getRecord(i);
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=hasConditions|class=node}{tr:id=name}{td}h6.hasConditions{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}hasConditions{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:hasConditions_des|trigger=button|text=}{sub-section}{sub-section:hasConditions_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:hasConditions_snc|trigger=button|text=}{sub-section}{sub-section:hasConditions_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:hasConditions_prs|trigger=button|text=}{sub-section}{sub-section:hasConditions_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:hasConditions_ret|trigger=button|text=}{sub-section}{sub-section:hasConditions_ret|trigger=none|class=sIndent}[Boolean] -- wether the foundset has find-conditions{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:hasConditions_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hasConditions_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:hasConditions_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hasConditions_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:hasConditions_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hasConditions_sam|trigger=none}{code:language=javascript}
if (forms.customer.foundset.hasConditions())
{
		// foundset had find actions
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=invertRecords|class=node}{tr:id=name}{td}h6.invertRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}invertRecords{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:invertRecords_des|trigger=button|text=}{sub-section}{sub-section:invertRecords_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:invertRecords_snc|trigger=button|text=}{sub-section}{sub-section:invertRecords_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:invertRecords_prs|trigger=button|text=}{sub-section}{sub-section:invertRecords_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:invertRecords_ret|trigger=button|text=}{sub-section}{sub-section:invertRecords_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:invertRecords_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:invertRecords_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:invertRecords_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:invertRecords_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:invertRecords_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:invertRecords_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.invertRecords();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isInFind|class=node}{tr:id=name}{td}h6.isInFind{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}isInFind{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:isInFind_des|trigger=button|text=}{sub-section}{sub-section:isInFind_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isInFind_snc|trigger=button|text=}{sub-section}{sub-section:isInFind_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:isInFind_prs|trigger=button|text=}{sub-section}{sub-section:isInFind_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:isInFind_ret|trigger=button|text=}{sub-section}{sub-section:isInFind_ret|trigger=none|class=sIndent}[Boolean] -- boolean is in find mode.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:isInFind_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isInFind_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:isInFind_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isInFind_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:isInFind_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:isInFind_sam|trigger=none}{code:language=javascript}
//Returns true when find was called on this foundset and search has not been called yet
forms.customer.foundset.isInFind();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=loadAllRecords|class=node}{tr:id=name}{td}h6.loadAllRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}loadAllRecords{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:loadAllRecords_des|trigger=button|text=}{sub-section}{sub-section:loadAllRecords_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:loadAllRecords_snc|trigger=button|text=}{sub-section}{sub-section:loadAllRecords_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:loadAllRecords_prs|trigger=button|text=}{sub-section}{sub-section:loadAllRecords_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:loadAllRecords_ret|trigger=button|text=}{sub-section}{sub-section:loadAllRecords_ret|trigger=none|class=sIndent}[Boolean] -- true if records are loaded, false otherwise.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:loadAllRecords_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadAllRecords_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:loadAllRecords_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadAllRecords_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:loadAllRecords_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadAllRecords_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.loadAllRecords();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=loadOmittedRecords|class=node}{tr:id=name}{td}h6.loadOmittedRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}loadOmittedRecords{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:loadOmittedRecords_des|trigger=button|text=}{sub-section}{sub-section:loadOmittedRecords_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:loadOmittedRecords_snc|trigger=button|text=}{sub-section}{sub-section:loadOmittedRecords_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:loadOmittedRecords_prs|trigger=button|text=}{sub-section}{sub-section:loadOmittedRecords_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:loadOmittedRecords_ret|trigger=button|text=}{sub-section}{sub-section:loadOmittedRecords_ret|trigger=none|class=sIndent}[Boolean] -- true if records are loaded, false otherwise.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:loadOmittedRecords_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadOmittedRecords_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:loadOmittedRecords_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadOmittedRecords_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:loadOmittedRecords_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadOmittedRecords_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.loadOmittedRecords();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=loadRecords|class=node}{tr:id=name}{td}h6.loadRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}loadRecords{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:loadRecords_des|trigger=button|text=}{sub-section}{sub-section:loadRecords_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:loadRecords_snc|trigger=button|text=}{sub-section}{sub-section:loadRecords_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:loadRecords_prs|trigger=button|text=}{sub-section}{sub-section:loadRecords_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:loadRecords_ret|trigger=button|text=}{sub-section}{sub-section:loadRecords_ret|trigger=none|class=sIndent}[Boolean] -- true if successful{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:loadRecords_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:loadRecords_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:loadRecords_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords_sam|trigger=none}{code:language=javascript}
//to reload all last (related) records again, if for example when searched in tabpanel
 forms.customer.foundset.loadRecords();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=loadRecords-JSFoundSet|class=node}{tr:id=name}{td}h6.loadRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}loadRecords{span}{span:id=iets|style=float: left;}\(foundset){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:loadRecords-JSFoundSet_des|trigger=button|text=}{sub-section}{sub-section:loadRecords-JSFoundSet_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:loadRecords-JSFoundSet_snc|trigger=button|text=}{sub-section}{sub-section:loadRecords-JSFoundSet_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:loadRecords-JSFoundSet_prs|trigger=button|text=}{sub-section}{sub-section:loadRecords-JSFoundSet_prs|trigger=none|class=sIndent}\{[JSFoundSet]} foundset -- The foundset to load records from
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:loadRecords-JSFoundSet_ret|trigger=button|text=}{sub-section}{sub-section:loadRecords-JSFoundSet_ret|trigger=none|class=sIndent}[Boolean] -- true if successful{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:loadRecords-JSFoundSet_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-JSFoundSet_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:loadRecords-JSFoundSet_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-JSFoundSet_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:loadRecords-JSFoundSet_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-JSFoundSet_sam|trigger=none}{code:language=javascript}
//Copies foundset data from another foundset
forms.customer.foundset.loadRecords(fs);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=loadRecords-JSDataSet|class=node}{tr:id=name}{td}h6.loadRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}loadRecords{span}{span:id=iets|style=float: left;}\(dataset){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:loadRecords-JSDataSet_des|trigger=button|text=}{sub-section}{sub-section:loadRecords-JSDataSet_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:loadRecords-JSDataSet_snc|trigger=button|text=}{sub-section}{sub-section:loadRecords-JSDataSet_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:loadRecords-JSDataSet_prs|trigger=button|text=}{sub-section}{sub-section:loadRecords-JSDataSet_prs|trigger=none|class=sIndent}\{[JSDataSet]} dataset -- pkdataset
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:loadRecords-JSDataSet_ret|trigger=button|text=}{sub-section}{sub-section:loadRecords-JSDataSet_ret|trigger=none|class=sIndent}[Boolean] -- true if successful{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:loadRecords-JSDataSet_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-JSDataSet_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:loadRecords-JSDataSet_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-JSDataSet_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:loadRecords-JSDataSet_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-JSDataSet_sam|trigger=none}{code:language=javascript}
// loads a primary key dataset, will remove related sort!
//var dataset = databaseManager.getDataSetByQuery(...);
// dataset must match the table primary key columns (alphabetically ordered)
forms.customer.foundset.loadRecords(dataset);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=loadRecords-QBSelect|class=node}{tr:id=name}{td}h6.loadRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}loadRecords{span}{span:id=iets|style=float: left;}\(querybuilder){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:loadRecords-QBSelect_des|trigger=button|text=}{sub-section}{sub-section:loadRecords-QBSelect_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:loadRecords-QBSelect_snc|trigger=button|text=}{sub-section}{sub-section:loadRecords-QBSelect_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:loadRecords-QBSelect_prs|trigger=button|text=}{sub-section}{sub-section:loadRecords-QBSelect_prs|trigger=none|class=sIndent}\{[QBSelect]} querybuilder -- the query builder
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:loadRecords-QBSelect_ret|trigger=button|text=}{sub-section}{sub-section:loadRecords-QBSelect_ret|trigger=none|class=sIndent}[Boolean] -- true if successful{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:loadRecords-QBSelect_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-QBSelect_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:loadRecords-QBSelect_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-QBSelect_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:loadRecords-QBSelect_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-QBSelect_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.loadRecords(qbselect);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=loadRecords-UUID|class=node}{tr:id=name}{td}h6.loadRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}loadRecords{span}{span:id=iets|style=float: left;}\(uuidpk){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:loadRecords-UUID_des|trigger=button|text=}{sub-section}{sub-section:loadRecords-UUID_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:loadRecords-UUID_snc|trigger=button|text=}{sub-section}{sub-section:loadRecords-UUID_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:loadRecords-UUID_prs|trigger=button|text=}{sub-section}{sub-section:loadRecords-UUID_prs|trigger=none|class=sIndent}\{[UUID]} uuidpk -- single\-column pk value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:loadRecords-UUID_ret|trigger=button|text=}{sub-section}{sub-section:loadRecords-UUID_ret|trigger=none|class=sIndent}[Boolean] -- true if successful{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:loadRecords-UUID_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-UUID_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:loadRecords-UUID_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-UUID_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:loadRecords-UUID_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-UUID_sam|trigger=none}{code:language=javascript}
//Loads a single record by primary key, will remove related sort!
forms.customer.foundset.loadRecords(application.getUUID('6b5e2f5d-047e-45b3-80ee-3a32267b1f20'));
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=loadRecords-Number|class=node}{tr:id=name}{td}h6.loadRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}loadRecords{span}{span:id=iets|style=float: left;}\(numberpk){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:loadRecords-Number_des|trigger=button|text=}{sub-section}{sub-section:loadRecords-Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:loadRecords-Number_snc|trigger=button|text=}{sub-section}{sub-section:loadRecords-Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:loadRecords-Number_prs|trigger=button|text=}{sub-section}{sub-section:loadRecords-Number_prs|trigger=none|class=sIndent}\{[Number]} numberpk -- single\-column pk value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:loadRecords-Number_ret|trigger=button|text=}{sub-section}{sub-section:loadRecords-Number_ret|trigger=none|class=sIndent}[Boolean] -- true if successful{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:loadRecords-Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:loadRecords-Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:loadRecords-Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-Number_sam|trigger=none}{code:language=javascript}
//Loads a single record by primary key, will remove related sort!
forms.customer.foundset.loadRecords(123);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=loadRecords-String|class=node}{tr:id=name}{td}h6.loadRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}loadRecords{span}{span:id=iets|style=float: left;}\(queryString){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:loadRecords-String_des|trigger=button|text=}{sub-section}{sub-section:loadRecords-String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:loadRecords-String_snc|trigger=button|text=}{sub-section}{sub-section:loadRecords-String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:loadRecords-String_prs|trigger=button|text=}{sub-section}{sub-section:loadRecords-String_prs|trigger=none|class=sIndent}\{[String]} queryString -- select statement
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:loadRecords-String_ret|trigger=button|text=}{sub-section}{sub-section:loadRecords-String_ret|trigger=none|class=sIndent}[Boolean] -- true if successful{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:loadRecords-String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:loadRecords-String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:loadRecords-String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-String_sam|trigger=none}{code:language=javascript}
//loads records in to the foundset based on a query (also known as 'Form by query')
forms.customer.foundset.loadRecords(sqlstring);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=loadRecords-String_ObjectArray|class=node}{tr:id=name}{td}h6.loadRecords{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}loadRecords{span}{span:id=iets|style=float: left;}\(queryString, argumentsArray){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:loadRecords-String_ObjectArray_des|trigger=button|text=}{sub-section}{sub-section:loadRecords-String_ObjectArray_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:loadRecords-String_ObjectArray_snc|trigger=button|text=}{sub-section}{sub-section:loadRecords-String_ObjectArray_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:loadRecords-String_ObjectArray_prs|trigger=button|text=}{sub-section}{sub-section:loadRecords-String_ObjectArray_prs|trigger=none|class=sIndent}\{[String]} queryString -- select statement
\{[Object]\[]} argumentsArray -- arguments to query
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:loadRecords-String_ObjectArray_ret|trigger=button|text=}{sub-section}{sub-section:loadRecords-String_ObjectArray_ret|trigger=none|class=sIndent}[Boolean] -- true if successful{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:loadRecords-String_ObjectArray_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-String_ObjectArray_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:loadRecords-String_ObjectArray_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-String_ObjectArray_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:loadRecords-String_ObjectArray_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:loadRecords-String_ObjectArray_sam|trigger=none}{code:language=javascript}
//loads records in to the foundset based on a query (also known as 'Form by query')
forms.customer.foundset.loadRecords(sqlstring,parameters);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=newRecord|class=node}{tr:id=name}{td}h6.newRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}newRecord{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:newRecord_des|trigger=button|text=}{sub-section}{sub-section:newRecord_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:newRecord_snc|trigger=button|text=}{sub-section}{sub-section:newRecord_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:newRecord_prs|trigger=button|text=}{sub-section}{sub-section:newRecord_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:newRecord_ret|trigger=button|text=}{sub-section}{sub-section:newRecord_ret|trigger=none|class=sIndent}[Number] -- int index of new record.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:newRecord_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:newRecord_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:newRecord_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord_sam|trigger=none}{code:language=javascript}
// foreign key data is only filled in for equals (=) relation items 
var idx = forms.customer.foundset.newRecord(false); // add as last record
// forms.customer.foundset.newRecord(); // adds as first record
// forms.customer.foundset.newRecord(2); //adds as second record
if (idx >= 0) // returned index is -1 in case of failure 
{
	forms.customer.foundset.some_column = "some text";
	application.output("added on position " + idx);
	// when adding at the end of the foundset, the returned index
	// corresponds with the size of the foundset
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=newRecord-Boolean|class=node}{tr:id=name}{td}h6.newRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}newRecord{span}{span:id=iets|style=float: left;}\(onTop){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:newRecord-Boolean_des|trigger=button|text=}{sub-section}{sub-section:newRecord-Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:newRecord-Boolean_snc|trigger=button|text=}{sub-section}{sub-section:newRecord-Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:newRecord-Boolean_prs|trigger=button|text=}{sub-section}{sub-section:newRecord-Boolean_prs|trigger=none|class=sIndent}\{[Boolean]} onTop -- when true the new record is added as the topmost record.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:newRecord-Boolean_ret|trigger=button|text=}{sub-section}{sub-section:newRecord-Boolean_ret|trigger=none|class=sIndent}[Number] -- int index of new record.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:newRecord-Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:newRecord-Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:newRecord-Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Boolean_sam|trigger=none}{code:language=javascript}
// foreign key data is only filled in for equals (=) relation items 
var idx = forms.customer.foundset.newRecord(false); // add as last record
// forms.customer.foundset.newRecord(); // adds as first record
// forms.customer.foundset.newRecord(2); //adds as second record
if (idx >= 0) // returned index is -1 in case of failure 
{
	forms.customer.foundset.some_column = "some text";
	application.output("added on position " + idx);
	// when adding at the end of the foundset, the returned index
	// corresponds with the size of the foundset
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=newRecord-Boolean_Boolean|class=node}{tr:id=name}{td}h6.newRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}newRecord{span}{span:id=iets|style=float: left;}\(onTop, changeSelection){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:newRecord-Boolean_Boolean_des|trigger=button|text=}{sub-section}{sub-section:newRecord-Boolean_Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:newRecord-Boolean_Boolean_snc|trigger=button|text=}{sub-section}{sub-section:newRecord-Boolean_Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:newRecord-Boolean_Boolean_prs|trigger=button|text=}{sub-section}{sub-section:newRecord-Boolean_Boolean_prs|trigger=none|class=sIndent}\{[Boolean]} onTop -- when true the new record is added as the topmost record.
\{[Boolean]} changeSelection -- when true the selection is changed to the new record.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:newRecord-Boolean_Boolean_ret|trigger=button|text=}{sub-section}{sub-section:newRecord-Boolean_Boolean_ret|trigger=none|class=sIndent}[Number] -- int index of new record.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:newRecord-Boolean_Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Boolean_Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:newRecord-Boolean_Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Boolean_Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:newRecord-Boolean_Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Boolean_Boolean_sam|trigger=none}{code:language=javascript}
// foreign key data is only filled in for equals (=) relation items 
var idx = forms.customer.foundset.newRecord(false); // add as last record
// forms.customer.foundset.newRecord(); // adds as first record
// forms.customer.foundset.newRecord(2); //adds as second record
if (idx >= 0) // returned index is -1 in case of failure 
{
	forms.customer.foundset.some_column = "some text";
	application.output("added on position " + idx);
	// when adding at the end of the foundset, the returned index
	// corresponds with the size of the foundset
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=newRecord-Number|class=node}{tr:id=name}{td}h6.newRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}newRecord{span}{span:id=iets|style=float: left;}\(index){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:newRecord-Number_des|trigger=button|text=}{sub-section}{sub-section:newRecord-Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:newRecord-Number_snc|trigger=button|text=}{sub-section}{sub-section:newRecord-Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:newRecord-Number_prs|trigger=button|text=}{sub-section}{sub-section:newRecord-Number_prs|trigger=none|class=sIndent}\{[Number]} index -- the new record is added at specified index.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:newRecord-Number_ret|trigger=button|text=}{sub-section}{sub-section:newRecord-Number_ret|trigger=none|class=sIndent}[Number] -- int index of new record.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:newRecord-Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:newRecord-Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:newRecord-Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Number_sam|trigger=none}{code:language=javascript}
// foreign key data is only filled in for equals (=) relation items 
var idx = forms.customer.foundset.newRecord(false); // add as last record
// forms.customer.foundset.newRecord(); // adds as first record
// forms.customer.foundset.newRecord(2); //adds as second record
if (idx >= 0) // returned index is -1 in case of failure 
{
	forms.customer.foundset.some_column = "some text";
	application.output("added on position " + idx);
	// when adding at the end of the foundset, the returned index
	// corresponds with the size of the foundset
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=newRecord-Number_Boolean|class=node}{tr:id=name}{td}h6.newRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}newRecord{span}{span:id=iets|style=float: left;}\(index, changeSelection){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:newRecord-Number_Boolean_des|trigger=button|text=}{sub-section}{sub-section:newRecord-Number_Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:newRecord-Number_Boolean_snc|trigger=button|text=}{sub-section}{sub-section:newRecord-Number_Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:newRecord-Number_Boolean_prs|trigger=button|text=}{sub-section}{sub-section:newRecord-Number_Boolean_prs|trigger=none|class=sIndent}\{[Number]} index -- the new record is added at specified index.
\{[Boolean]} changeSelection -- when true the selection is changed to the new record.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:newRecord-Number_Boolean_ret|trigger=button|text=}{sub-section}{sub-section:newRecord-Number_Boolean_ret|trigger=none|class=sIndent}[Number] -- int index of new record.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:newRecord-Number_Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Number_Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:newRecord-Number_Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Number_Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:newRecord-Number_Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:newRecord-Number_Boolean_sam|trigger=none}{code:language=javascript}
// foreign key data is only filled in for equals (=) relation items 
var idx = forms.customer.foundset.newRecord(false); // add as last record
// forms.customer.foundset.newRecord(); // adds as first record
// forms.customer.foundset.newRecord(2); //adds as second record
if (idx >= 0) // returned index is -1 in case of failure 
{
	forms.customer.foundset.some_column = "some text";
	application.output("added on position " + idx);
	// when adding at the end of the foundset, the returned index
	// corresponds with the size of the foundset
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=omitRecord|class=node}{tr:id=name}{td}h6.omitRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}omitRecord{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:omitRecord_des|trigger=button|text=}{sub-section}{sub-section:omitRecord_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:omitRecord_snc|trigger=button|text=}{sub-section}{sub-section:omitRecord_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:omitRecord_prs|trigger=button|text=}{sub-section}{sub-section:omitRecord_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:omitRecord_ret|trigger=button|text=}{sub-section}{sub-section:omitRecord_ret|trigger=none|class=sIndent}[Boolean] -- boolean true if all records could be omitted.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:omitRecord_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:omitRecord_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:omitRecord_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:omitRecord_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:omitRecord_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:omitRecord_sam|trigger=none}{code:language=javascript}
var success = forms.customer.foundset.omitRecord();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=omitRecord-Number|class=node}{tr:id=name}{td}h6.omitRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}omitRecord{span}{span:id=iets|style=float: left;}\(index){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:omitRecord-Number_des|trigger=button|text=}{sub-section}{sub-section:omitRecord-Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:omitRecord-Number_snc|trigger=button|text=}{sub-section}{sub-section:omitRecord-Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:omitRecord-Number_prs|trigger=button|text=}{sub-section}{sub-section:omitRecord-Number_prs|trigger=none|class=sIndent}\{[Number]} index -- The index of the record to omit.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:omitRecord-Number_ret|trigger=button|text=}{sub-section}{sub-section:omitRecord-Number_ret|trigger=none|class=sIndent}[Boolean] -- boolean true if all records could be omitted.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:omitRecord-Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:omitRecord-Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:omitRecord-Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:omitRecord-Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:omitRecord-Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:omitRecord-Number_sam|trigger=none}{code:language=javascript}
var success = forms.customer.foundset.omitRecord();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=relookup|class=node}{tr:id=name}{td}h6.relookup{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}relookup{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:relookup_des|trigger=button|text=}{sub-section}{sub-section:relookup_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:relookup_snc|trigger=button|text=}{sub-section}{sub-section:relookup_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:relookup_prs|trigger=button|text=}{sub-section}{sub-section:relookup_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:relookup_ret|trigger=button|text=}{sub-section}{sub-section:relookup_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:relookup_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:relookup_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:relookup_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:relookup_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:relookup_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:relookup_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.relookup(1);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=relookup-Number|class=node}{tr:id=name}{td}h6.relookup{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}relookup{span}{span:id=iets|style=float: left;}\(index){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:relookup-Number_des|trigger=button|text=}{sub-section}{sub-section:relookup-Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:relookup-Number_snc|trigger=button|text=}{sub-section}{sub-section:relookup-Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:relookup-Number_prs|trigger=button|text=}{sub-section}{sub-section:relookup-Number_prs|trigger=none|class=sIndent}\{[Number]} index -- record index (1\-based)
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:relookup-Number_ret|trigger=button|text=}{sub-section}{sub-section:relookup-Number_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:relookup-Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:relookup-Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:relookup-Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:relookup-Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:relookup-Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:relookup-Number_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.relookup(1);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=removeFoundSetFilterParam-String|class=node}{tr:id=name}{td}h6.removeFoundSetFilterParam{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}removeFoundSetFilterParam{span}{span:id=iets|style=float: left;}\(name){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:removeFoundSetFilterParam-String_des|trigger=button|text=}{sub-section}{sub-section:removeFoundSetFilterParam-String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:removeFoundSetFilterParam-String_snc|trigger=button|text=}{sub-section}{sub-section:removeFoundSetFilterParam-String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:removeFoundSetFilterParam-String_prs|trigger=button|text=}{sub-section}{sub-section:removeFoundSetFilterParam-String_prs|trigger=none|class=sIndent}\{[String]} name -- String filter name.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:removeFoundSetFilterParam-String_ret|trigger=button|text=}{sub-section}{sub-section:removeFoundSetFilterParam-String_ret|trigger=none|class=sIndent}[Boolean] -- true if removing the filter succeeded, false otherwise.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:removeFoundSetFilterParam-String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:removeFoundSetFilterParam-String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:removeFoundSetFilterParam-String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:removeFoundSetFilterParam-String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:removeFoundSetFilterParam-String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:removeFoundSetFilterParam-String_sam|trigger=none}{code:language=javascript}
var success = forms.customer.foundset.removeFoundSetFilterParam('custFilter');// removes all filters with this name
forms.customer.foundset.loadAllRecords();//to make param(s) effective
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=search|class=node}{tr:id=name}{td}h6.search{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}search{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:search_des|trigger=button|text=}{sub-section}{sub-section:search_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:search_snc|trigger=button|text=}{sub-section}{sub-section:search_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:search_prs|trigger=button|text=}{sub-section}{sub-section:search_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:search_ret|trigger=button|text=}{sub-section}{sub-section:search_ret|trigger=none|class=sIndent}[Number] -- the recordCount{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:search_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:search_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:search_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:search_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:search_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:search_sam|trigger=none}{code:language=javascript}
var recordCount = forms.customer.foundset.search();
//var recordCount = forms.customer.foundset.search(false,false); //to extend foundset
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=search-Boolean|class=node}{tr:id=name}{td}h6.search{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}search{span}{span:id=iets|style=float: left;}\(clearLastResults){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:search-Boolean_des|trigger=button|text=}{sub-section}{sub-section:search-Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:search-Boolean_snc|trigger=button|text=}{sub-section}{sub-section:search-Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:search-Boolean_prs|trigger=button|text=}{sub-section}{sub-section:search-Boolean_prs|trigger=none|class=sIndent}\{[Boolean]} clearLastResults -- boolean, clear previous search, default true
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:search-Boolean_ret|trigger=button|text=}{sub-section}{sub-section:search-Boolean_ret|trigger=none|class=sIndent}[Number] -- the recordCount{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:search-Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:search-Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:search-Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:search-Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:search-Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:search-Boolean_sam|trigger=none}{code:language=javascript}
var recordCount = forms.customer.foundset.search();
//var recordCount = forms.customer.foundset.search(false,false); //to extend foundset
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=search-Boolean_Boolean|class=node}{tr:id=name}{td}h6.search{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}search{span}{span:id=iets|style=float: left;}\(clearLastResults, reduceSearch){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:search-Boolean_Boolean_des|trigger=button|text=}{sub-section}{sub-section:search-Boolean_Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:search-Boolean_Boolean_snc|trigger=button|text=}{sub-section}{sub-section:search-Boolean_Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:search-Boolean_Boolean_prs|trigger=button|text=}{sub-section}{sub-section:search-Boolean_Boolean_prs|trigger=none|class=sIndent}\{[Boolean]} clearLastResults -- boolean, clear previous search, default true
\{[Boolean]} reduceSearch -- boolean, reduce (true) or extend (false) previous search results, default true
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:search-Boolean_Boolean_ret|trigger=button|text=}{sub-section}{sub-section:search-Boolean_Boolean_ret|trigger=none|class=sIndent}[Number] -- the recordCount{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:search-Boolean_Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:search-Boolean_Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:search-Boolean_Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:search-Boolean_Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:search-Boolean_Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:search-Boolean_Boolean_sam|trigger=none}{code:language=javascript}
var recordCount = forms.customer.foundset.search();
//var recordCount = forms.customer.foundset.search(false,false); //to extend foundset
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=selectRecord-__|class=node}{tr:id=name}{td}h6.selectRecord{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}selectRecord{span}{span:id=iets|style=float: left;}\(pkid1, \[pkid2\], \[pkidn\]){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:selectRecord-___des|trigger=button|text=}{sub-section}{sub-section:selectRecord-___des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:selectRecord-___snc|trigger=button|text=}{sub-section}{sub-section:selectRecord-___snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:selectRecord-___prs|trigger=button|text=}{sub-section}{sub-section:selectRecord-___prs|trigger=none|class=sIndent}pkid1 -- primary key
\[pkid2\] -- second primary key (in case of composite primary key)
\[pkidn\] -- nth primary key
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:selectRecord-___ret|trigger=button|text=}{sub-section}{sub-section:selectRecord-___ret|trigger=none|class=sIndent}[Boolean] -- true if succeeded.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:selectRecord-___see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:selectRecord-___see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:selectRecord-___link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:selectRecord-___link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:selectRecord-___sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:selectRecord-___sam|trigger=none}{code:language=javascript}
forms.customer.foundset.selectRecord(pkid1,pkid2,pkidn);//pks must be alphabetically set! It is also possible to use an array as parameter.
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=setDataProviderValue-String_Object|class=node}{tr:id=name}{td}h6.setDataProviderValue{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}setDataProviderValue{span}{span:id=iets|style=float: left;}\(dataProviderID, value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:setDataProviderValue-String_Object_des|trigger=button|text=}{sub-section}{sub-section:setDataProviderValue-String_Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:setDataProviderValue-String_Object_snc|trigger=button|text=}{sub-section}{sub-section:setDataProviderValue-String_Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:setDataProviderValue-String_Object_prs|trigger=button|text=}{sub-section}{sub-section:setDataProviderValue-String_Object_prs|trigger=none|class=sIndent}\{[String]} dataProviderID -- data provider name
\{[Object]} value -- value to set
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:setDataProviderValue-String_Object_ret|trigger=button|text=}{sub-section}{sub-section:setDataProviderValue-String_Object_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:setDataProviderValue-String_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:setDataProviderValue-String_Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:setDataProviderValue-String_Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:setDataProviderValue-String_Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:setDataProviderValue-String_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:setDataProviderValue-String_Object_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.setDataProviderValue('contact_name','mycompany');
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=setSelectedIndex-Number|class=node}{tr:id=name}{td}h6.setSelectedIndex{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}setSelectedIndex{span}{span:id=iets|style=float: left;}\(index){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:setSelectedIndex-Number_des|trigger=button|text=}{sub-section}{sub-section:setSelectedIndex-Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:setSelectedIndex-Number_snc|trigger=button|text=}{sub-section}{sub-section:setSelectedIndex-Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:setSelectedIndex-Number_prs|trigger=button|text=}{sub-section}{sub-section:setSelectedIndex-Number_prs|trigger=none|class=sIndent}\{[Number]} index -- index to set (1\-based)
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:setSelectedIndex-Number_ret|trigger=button|text=}{sub-section}{sub-section:setSelectedIndex-Number_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:setSelectedIndex-Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:setSelectedIndex-Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:setSelectedIndex-Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:setSelectedIndex-Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:setSelectedIndex-Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:setSelectedIndex-Number_sam|trigger=none}{code:language=javascript}
//gets the current record index in the current foundset
var current = forms.customer.foundset.getSelectedIndex();
//sets the next record in the foundset
forms.customer.foundset.setSelectedIndex(current+1);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=setSelectedIndexes-NumberArray|class=node}{tr:id=name}{td}h6.setSelectedIndexes{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}setSelectedIndexes{span}{span:id=iets|style=float: left;}\(indexes){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:setSelectedIndexes-NumberArray_des|trigger=button|text=}{sub-section}{sub-section:setSelectedIndexes-NumberArray_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:setSelectedIndexes-NumberArray_snc|trigger=button|text=}{sub-section}{sub-section:setSelectedIndexes-NumberArray_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:setSelectedIndexes-NumberArray_prs|trigger=button|text=}{sub-section}{sub-section:setSelectedIndexes-NumberArray_prs|trigger=none|class=sIndent}\{[Number]\[]} indexes -- An array with indexes to set.
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:setSelectedIndexes-NumberArray_ret|trigger=button|text=}{sub-section}{sub-section:setSelectedIndexes-NumberArray_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:setSelectedIndexes-NumberArray_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:setSelectedIndexes-NumberArray_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:setSelectedIndexes-NumberArray_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:setSelectedIndexes-NumberArray_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:setSelectedIndexes-NumberArray_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:setSelectedIndexes-NumberArray_sam|trigger=none}{code:language=javascript}
// modify selection to the first selected item and the following row only
var current = forms.customer.foundset.getSelectedIndexes();
if (current.length > 1)
{
	var newSelection = new Array();
	newSelection[0] = current[0]; // first current selection
	newSelection[1] = current[0] + 1; // and the next row
	forms.customer.foundset.setSelectedIndexes(newSelection);
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sort-String|class=node}{tr:id=name}{td}h6.sort{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}sort{span}{span:id=iets|style=float: left;}\(sortString){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:sort-String_des|trigger=button|text=}{sub-section}{sub-section:sort-String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:sort-String_snc|trigger=button|text=}{sub-section}{sub-section:sort-String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:sort-String_prs|trigger=button|text=}{sub-section}{sub-section:sort-String_prs|trigger=none|class=sIndent}\{[String]} sortString -- the specified columns (and sort order)
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:sort-String_ret|trigger=button|text=}{sub-section}{sub-section:sort-String_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:sort-String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sort-String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:sort-String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sort-String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:sort-String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sort-String_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.sort('columnA desc,columnB asc');
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sort-String_Boolean|class=node}{tr:id=name}{td}h6.sort{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}sort{span}{span:id=iets|style=float: left;}\(sortString, defer){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:sort-String_Boolean_des|trigger=button|text=}{sub-section}{sub-section:sort-String_Boolean_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:sort-String_Boolean_snc|trigger=button|text=}{sub-section}{sub-section:sort-String_Boolean_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:sort-String_Boolean_prs|trigger=button|text=}{sub-section}{sub-section:sort-String_Boolean_prs|trigger=none|class=sIndent}\{[String]} sortString -- the specified columns (and sort order)
\{[Boolean]} defer -- when true, the "sortString" will be just stored, without performing a query on the database (the actual sorting will be deferred until the next data loading action).
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:sort-String_Boolean_ret|trigger=button|text=}{sub-section}{sub-section:sort-String_Boolean_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:sort-String_Boolean_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sort-String_Boolean_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:sort-String_Boolean_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sort-String_Boolean_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:sort-String_Boolean_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sort-String_Boolean_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.sort('columnA desc,columnB asc');
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sort-Function|class=node}{tr:id=name}{td}h6.sort{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}sort{span}{span:id=iets|style=float: left;}\(recordComparisonFunction){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:sort-Function_des|trigger=button|text=}{sub-section}{sub-section:sort-Function_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:sort-Function_snc|trigger=button|text=}{sub-section}{sub-section:sort-Function_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:sort-Function_prs|trigger=button|text=}{sub-section}{sub-section:sort-Function_prs|trigger=none|class=sIndent}\{[Function]} recordComparisonFunction -- record comparator function
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:sort-Function_ret|trigger=button|text=}{sub-section}{sub-section:sort-Function_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:sort-Function_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sort-Function_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:sort-Function_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sort-Function_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:sort-Function_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sort-Function_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.sort(mySortFunction);

function mySortFunction(r1, r2)
{
	var o = 0;
	if(r1.id < r2.id)
	{
		o = -1;
	}
	else if(r1.id > r2.id)
	{
		o = 1;
	}
	return o;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=unrelate|class=node}{tr:id=name}{td}h6.unrelate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[JSFoundSet]{span}{span:id=iets|style=float: left; font-weight: bold;}unrelate{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:unrelate_des|trigger=button|text=}{sub-section}{sub-section:unrelate_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:unrelate_snc|trigger=button|text=}{sub-section}{sub-section:unrelate_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:unrelate_prs|trigger=button|text=}{sub-section}{sub-section:unrelate_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:unrelate_ret|trigger=button|text=}{sub-section}{sub-section:unrelate_ret|trigger=none|class=sIndent}[JSFoundSet] -- FoundSet unrelated foundset.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:unrelate_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:unrelate_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:unrelate_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:unrelate_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:unrelate_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:unrelate_sam|trigger=none}{code:language=javascript}
forms.customer.foundset.unrelate();
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}