...
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
HTML Table |
---|
|
Table Row (tr) |
---|
| Table Head (th) |
---|
| Property Summary |
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#multiSelect Get or set the multiSelect flag of the foundset. |
|
|
|
HTML Table |
id |
---|
|
Table Row (tr) |
---|
| Table Head (th) |
---|
| Method Summary |
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#addFoundSetFilterParam(dataprovider, operator, value) Add a filter parameter that is permanent per user session to limit a specified foundset of records. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#addFoundSetFilterParam(dataprovider, operator, value, name) Add a filter parameter that is permanent per user session to limit a specified foundset of records. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#clear() Clear the foundset. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#deleteAllRecords() Delete all records in foundset, resulting in empty foundset. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#deleteRecord([index/record]) Delete current/parameter record or the record under the given index. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#duplicateRecord([index], [location], [changeSelection]) Duplicate current record or record at index in the foundset. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#find() Set the foundset in find mode. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#getRecord(index) Get the record object at the index. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#getRelationName() Gets the relation name (null if not a related foundset). |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#getSize() Get the number of records in this foundset. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#invertRecords() Invert the foundset against all rows of the current table. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#isInFind() Check if this foundset is in find mode. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#loadAllRecords() Loads all accessible records from the datasource into the foundset. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#loadOmittedRecords() Loads the records that are currently omitted as a foundset. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#loadRecords([input], [queryArgumentsArray]) Load records with primary key (dataset/number/uuid) or query. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#newRecord([location], [changeSelection]) Create a new record in the foundset. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#omitRecord([index]) Omit current record or the record under the given index, to be shown with loadOmittedRecords. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#relookup([index]) Perform a relookup for the current record or 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. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#search([clearLastResults], [reduceSearch]) Start the database search and use the results, returns the number of records, make sure you did "find" function first. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#selectRecord(pkid1, [pkid2], [pkidn]) Select the record based on pk data. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#sort(sortString/recordComparator, [defer]) Sorts the foundset based on the given sort string or record comparator function. |
|
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#unrelate() Create a new unrelated foundset that is a copy of the current foundset. |
|
|
|
...