Assuming modifiedtime is required, the following 2 results were found.
all which has all the data for my widgets), I have to write it as such: SELECT 'CRM Accounts' AS "DataSource", date(t1."ModifiedTime") AS "Date", t1."RecordID" AS "Record ID", t1."RecordName" AS "Record Name", t1."RecordOwner" AS "Record Owner",...
= ifnull(r_Result.get("Total_Amount"),0.0).toDecimal(); v_ExchangeRate = ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime = ifnull(r_Result.get("Modified_Time"),r_Result.get("Added_Time")).toTime().toString("dd/MM/yyyy hh:mm a"); // // future...