Function to search for the member quantity from an Item Group

Jira Code : BGGN-719

/**
 * To fetch the quantity of the member item from an Item group
 * @param itemGrp
 * @param memberItem
 * @returns memberQty
*/
        function findItemGrp_ComponentQty(itemGrp, memberItem)
        {
            try
            {
                var itemgroupSearchObj = search.create({
                    type: "itemgroup",
                    filters:
                        [
                            ["type","anyof","Group"],
                            "AND",
                            ["internalidnumber","equalto",itemGrp],
                            "AND",
                            ["memberitem.internalidnumber","equalto", memberItem]
                        ],
                    columns:
                        [
                            search.createColumn({name: "memberquantity", label: "MemberQuantity"})
                        ]
                });

                var searchResult = itemgroupSearchObj .runPaged();
                searchResult.pageRanges.forEach(function (pageRange)
                {
                    let myPage = searchResult.fetch({ index: pageRange.index });
                    myPage.data.forEach(function (result)
                    {
                        let memberQty=result.getValue({name: "memberquantity", label: "MemberQuantity"});
                        return memberQty;
                    });
                });
            }
            catch (e)
            {
                log.debug("Error @ findItemGrp_ComponentQty", e);
            }
        }

Leave a comment

Your email address will not be published. Required fields are marked *