message.sortCSVByDate

Signature: message.sortCSVByDate(sortNodePath, descending*)

Returns: void

Sorts the CSV by date based on the sortNodePath.

Note

This method only applies to CSV formatted messages.

Parameters

Type	Name	Description	Default
String	sortNodePath	the column of the CSV to sort on
Boolean	descending*	(optional) when true sorts in descending order	false

Example

// Example: Sort CSV rows by a date column (name or index).

// Sample CSV message structure
message = qie.createCSVMessage(
    "Name,Age,DOB\n" +
    "Alice,30,1992-03-15\n" +
    "Bob,25,1997-08-22\n" +
    "Charlie,35,1987-11-10\n", // value
    false,                     // quote values
    '"',                       // quote char
    ",",                       // separator
    "UTF-8",                   // charset
    true                       // contains header
);

// Sort by date column (ascending) using column name
message.sortCSVByDate(
    "DOB" // column name
);
var firstNameAfterAsc = message.getNode("Name", 1); // "Charlie"
var lastNameAfterAsc  = message.getNode("Name", 3); // "Bob"

// Sort by date column (descending) using column index
message.sortCSVByDate(
    "3",   // column index ("DOB")
    true   // descending
);
var firstNameAfterDesc = message.getNode("Name", 1); // "Bob"
var lastNameAfterDesc  = message.getNode("Name", 3); // "Charlie"