const getBomQuantity = (versionId) => {
let suiteQL =
"SELECT " +
"bomRevisionComponentMember.bomquantity, " +
"bomRevisionComponentMember.componentYield, " +
"bomRevisionComponentMember.item, " +
"FROM " +
"bomRevisionComponentMember " +
"INNER JOIN bomRevision ON " +
"bomRevisionComponentMember.bomrevision = bomRevision.id " +
"WHERE " +
`bomRevision.id=${versionId}`
return query.runSuiteQL(suiteQL).asMappedResults()
}
example output
[{"bomquantity":18,"componentyield":0.98,"item":41396},{"bomquantity":0.01980198,"componentyield":0.99,"item":28281},{"bomquantity":1.11584158,"componentyield":0.99,"item":28284},{"bomquantity":1.0990099,"componentyield":0.99,"item":28273},{"bomquantity":0.00970297,"componentyield":0.99,"item":28276}]
Comments