is there a way to get an exportable list of all it...
# generalj
jen
03/02/2023, 5:59 PMis there a way to get an exportable list of all item groups with their individual items, in the order that those items appear in the group ?
jen
03/02/2023, 6:50 PMEnded up using SuiteQL
jen
03/02/2023, 6:50 PM Copy code
SELECT package.id AS package_id, package.fullname AS package_name, package.displayname AS package_displayname,
packageitem.id AS item_id, packageitem.fullname AS item_name, packageitem.displayname AS item_displayname
FROM item package
JOIN itemgroupmember ON itemgroupmember.parentitem = package.id
JOIN item packageitem ON itemgroupmember.item = packageitem.id
ORDER BY package.fullname, itemgroupmember.linenumber3 Views