In Report's i need to sort the data based on SLA Number by selection supplier in trend report

Swathi KS
Tera Contributor

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