Page History

...

• When a form to which it is bound is loaded
• When the loadRecords method is called programmatically
• When the sort definition is changed
• When it exits find mode

Loading Records Programmatically

...

var sql = 'select id from my_table where my_table.column1 in ?,?,?;
var args = [1,2,3];
foundset.loadRecords(sql, args);

Sorting

All foundsets contain a sorting definition that determines the order in which records are loaded and displayed. Sorting is always expressed in the ORDER BY clause of a foundset's query and thus handled by the database.

...