Hi All,
APEX 5.1
In previous versions, I get data out of, and set data in my TAB Form using JQuery to traverse the table to get and set the data. for Example, a "Change" DA would fire via its column jquery selector to change the value of another field on the same row:
var row = $(this.triggeringElement).closest("tr");
var desc = row.find('[headers="CODE_DESCRIPTION"]');
desc.val('Set New Value');
In Interactive Grid, I gather I need to use the data model and get and set the data from there. I can see from the API that I can get and set the record value (SetRecordValue), but how do I get the record ID from the current row that I've changed a value on? Also, if I do change another value in the model, will it automatically update the data on screen?
On a related note. (I know its a different question). If I want to Count or Sum the total of a column or records from the model, how can I guarantee (or force) that the model has all the data?
Many Thanks
Richard