2022.2

var row = query("tbody tr", results).clone();
query("tbody", results).append(row);
Thefollowingscriptclonesanexistingtablerowtomatchthenumberofrowsinadetailtable.After-
wardsititeratesovertherowstopopulatethefields.
// Create the number of rows based on the records in the detail table
// We start at 1 so the boilerplate row is used too and there is no need to delete that row
for(var r = 1; r < record.tables['detail'].length; r++) {
results.parent().append(results.clone());
}
// Iterate over the rows and populate them with the data from the accompanying data row
query("#table_2 > tbody > tr").each(function(i) {
this.find('@ItemNumber@').text( record.tables['detail'][i].fields["ItemNumber"]);
this.find('@ItemOrdered@').text( record.tables['detail'][i].fields["ItemOrdered"]);
this.find('@ItemTotal@').text( record.tables['detail'][i].fields["ItemTotal"]);
this.find('@ItemDesc@').text( record.tables['detail'][i].fields["ItemDesc"]);
this.find('@nr@').text(i);
});
Thefollowingscriptclonesandpopulatesaboilerplaterow.Oncecompletedyouwillneedtohidethe
boilerplaterow.
for(var i = 0; i < record.tables['detail'].length; i++) {
var row = results.clone(); //Clone our boilerplate row
row.find('@ItemNumber@').text( record.tables['detail'][i].fields["ItemNumber"]);
row.find('@ItemOrdered@').text( record.tables['detail'][i].fields["ItemOrdered"]);
row.find('@ItemTotal@').text( record.tables['detail'][i].fields["ItemTotal"]);
row.find('@ItemDesc@').text( record.tables['detail'][i].fields["ItemDesc"]);
row.find('@nr@').text( i );
results.parent().append(row);
}
// Hide our boilerplate row (note that this doesn't really delete the row).
results.hide();
closest()
Thisfunctiongetsthefirstparentelementthatmatchesaselector,bytestingtheelementitselfandtra-
versingupthroughitsancestorsintheDOMtree.(InHTML,aparentisanelementthatcontains
anotherelement.)
Thefunctioncanbeusedfor:
l
Theelementsthatmatchtheselectorofascript(see"results"onpage1301).
l
Oneelementthatmatchestheselectorofascriptthatrunsfor"Eachmatchedelement"(see
"this"onpage1237and"Settingthescopeofascript"onpage813).
l
Theelementsreturnedbyaqueryinthetemplate(see"query()"onpage1197).
Togetachildelementorallchildelements,usechildren()(see"children()"onthepreviouspage).
Page 1251