JR
08/09/2023, 6:15 PMvar caseList = sqlQueryRunCaseList(startDate, endDate);
var caseListRecord = caseList[c];
var caseNumber = caseListRecord.casenumber;
var status = caseListRecord.status;
var createddate = caseListRecord.startDate;
var closedate = caseListRecord.endDate;
The Query:
SELECT
casenumber, custevent8, custevent_refund_cost, id, title, status, startDate, endDate
FROM
supportCase
WHERE
profile=6
AND startDate >= '${startDate}'
AND startDate <= '${endDate}'
Watz
08/09/2023, 8:10 PMWatz
08/09/2023, 8:12 PMstartDate >= to_date('${startDate}', 'yyyy-mm-dd')
JR
08/09/2023, 8:18 PMJR
08/10/2023, 3:09 PMreturn query.runSuiteQL( { query: sql, params: [] } ).asMappedResults();
So that's fine. If I print the CaseListRecord, the log only says it's an object. If i JSON stringify it like below I get the following. So, the dates are present.
var myObj = JSON.stringify(caseListRecord);
I just don't know how to access it. my simple assignment show nothing as well as numerous iterations of of trying. I'm sure there is a simple solution, but i can't seem to find it!Watz
08/10/2023, 3:21 PMWatz
08/10/2023, 3:22 PMWatz
08/10/2023, 3:22 PMJR
08/10/2023, 5:37 PMWatz
08/10/2023, 5:39 PMJR
08/10/2023, 5:42 PM