@Aman Thakur
try this
1) first gather all the records
2) then iterate over those
var gr = new GlideRecord("table_1");
gr.addEncodedQuery("end_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()^u_status=In progress^u_related_ritm.cat_item=7557fae6dbd928105bdb20da1396191a");
gr.query();
var orders = [];
while (gr.next()) {
var rel_ritm = new GlideRecord('sc_req_item');
rel_ritm.addQuery('sys_id', gr.ritm);
rel_ritm.query();
if (rel_ritm.next()) {
var req = new GlideRecord('sc_request');
req.addQuery('sys_id', rel_ritm.request);
req.query();
if (req.next()) {
orders.push({
requested_for: req.requested_for,
requested_by: rel_ritm.opened_by,
original_ritm: gr.ritm
});
}
}
}
// Place orders outside the loop
var cat_id = 'd8db28c6db3ca0d03a99467239963540';
orders.forEach(function(order) {
var cart = new Cart();
var item = cart.addItem(cat_id);
cart.setVariable(item, 'requested_for', order.requested_for);
cart.setVariable(item, 'requested_by', order.requested_by);
cart.setVariable(item, 'original_ritm', order.original_ritm);
var rc = cart.placeOrder();
cart.deleteCart();
});
If my response helped please mark it correct and close the thread so that it benefits future readers.
Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
