I can query the records and display the dataset correctly for either of these two scenarios, but when one tabpanel is loaded with a dataset, it changes the other tabpanel to that same dataset. How can I display different datasets of the same table on a single form?
- Code: Select all
//find and load records into the first tabpanel
var user = globals.currentUser
var query = "SELECT sir_id FROM aissp WHERE assigned = ? ORDER BY is_num";
var dataset = databaseManager.getDataSetByQuery(controller.getServerName(),query, [user],maxReturnedRows);
forms.form1.controller.loadRecords(dataset);
//find and load records into the second tabpanel
var date = new Date();
var query2 = "SELECT sir_id FROM aissp WHERE expiration < ? ORDER BY expiration";
var dataset2 = databaseManager.getDataSetByQuery(controller.getServerName(),query2, [date],maxReturnedRows);
forms.form2.controller.loadRecords(dataset2);