I have the following code, which normally works to sort calls by created time. Every once in a while, it doesn't work and something sneaks through in the wrong order and I can't figure out why.
calls = zoho.crm.searchRecords("Calls","(Owner:equals:" + user_id + ")and(Call_Type:equals:Inbound)",1,200);
callList = List();
for each call in calls
{
callData = Map();
callData.put("Created_Time",call.get("Created_Time"));
callData.put("Call_id",call.get("id"));
callList.add(callData);
}
sortedCalls = callList.sort(false);
info "Sorted Calls List: " + sortedCalls;
sortAgain = sortedCalls.sort(false);
info "Sorted twice: " + sortAgain;
Here is the first part of some of my info statements, you'll see the incorrect sorting with the first call occurring earlier than the second:
"Sorted Calls List: {"Created_Time":"2025-01-07T08:13:37-07:00"},{"Created_Time":"2025-01-07T15:48:40-07:00"}
"Sorted twice: {"Created_Time":"2025-01-07T08:13:37-07:00"},{"Created_Time":"2025-01-07T15:48:40-07:00"},{"Created_Time":"2025-01-07T13:59:08-07:00"}