In Report's i need to sort the data based on SLA Number by selection supplier in trend report
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-11-2024 09:05 AM
I have written some script but because of SLA number field was string field it was not sorting the way i want
if (input.selectedSupplier == 'all') {
// Sort alphabetically by supplier_name when 'all' is selected
gr.orderBy('slt_id.master_contract_id.sup_id.supplier');
gr.orderBy('met_num');
} else {
// Sort by met_num when a specific supplier is selected
gr.addQuery('Supplier',input.selectedSupplier);
gr.orderBy('met_num');
}
here is the script it was sorting but it was string field so i need to sort only in number like if SLA number data contains CSL - 1, KM - 11 , CSL - 2
Sort should be : CSL - 1, CSL - 2, KM - 11
Please help me resolve this issue
0 REPLIES 0