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}]	
Last modified: 18/10/2023

Author

Comments

Write a Reply or Comment

Your email address will not be published.