79720686

Date: 2025-07-31 01:52:40
Score: 1
Natty:
Report link

Looks like I was too smart by half. I already had the value. Thanks to the people who responded, it made me think harder :0)

var invoiceItemCntResult = query.runSuiteQL({
    query: 'select trandisplayname
    from transaction
    left join transactionline
    on transaction.id=transactionline.transaction
    WHERE custcol_cp_year > 0
    and custcol_cp_carrierid !== null
    and transaction.externalID = ?', params: [externalID]});              
var invoiceItemCnt = invoiceItemCntResult.asMappedResults();       

//Log ItemCnt
log.debug({
title: '1a. ItemCnt',
details: JSON.stringify(invoiceItemCnt.length)});
Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: RayJohn