How to sort result set from getRecords

Hi,

I want to sort the result by the "Reporting_To". If someone could assist.

-----------------------------------------------------------------------------------------------------------------------------

listVar = list();

//Create map to hold search condition 1

searchMap1 = Map();

searchMap1.put("searchField","Date_of_the_next_appraisal_auto_field_update_manual_override");

searchMap1.put("searchOperator","Is");

searchMap1.put("searchText","01-Dec-2022");

searchList = List();

searchList.add(searchMap1);

//Create map to hold search condition 2

searchMap2 = Map();

searchMap2.put("searchField","Employeestatus");

searchMap2.put("searchOperator","Is");

searchMap2.put("searchText","Active");

////Create list to hold all the search conditions

searchList = List();

searchList.add(searchMap1);

searchList.add(searchMap2);

// Execute the get records task to fetch the search result

response = zoho.people.getRecords("P_Employee",0,200,searchList);

//info response;

for each RecordList in response

{

EeID = RecordList.get("EmployeeID");

Lname = RecordList.get("LastName");

Fname = RecordList.get("FirstName");

Reporting1 = RecordList.get("Reporting_To");

info EeID + " " + Lname + " " + Fname + " - " + Reporting1;

InfoEe = EeID.concat(" ").concat(Lname).concat(" ").concat(Fname);

listVar.add(InfoEe);

}

--------------------------------------------------------------------------------------------------------

Thanks

Topic Participants