Report on Active Category, Sub-Category and Item
Hi,
Can you provide the query to display only Active (in use) Category, Sub-category and Item?
Found this somewhere in the forums but it lists ALL of them.
SELECT cat.CategoryName "Category" , sub.NAME "Subcategory",(SELECT STUFF((SELECT NAME + CHAR(10) FROM ItemDefinition item where sub.SUBCATEGORYID=Item.SUBCATEGORYID
order by 1 FOR XML PATH ('')), 1, 0, '')) "Item" FROM CategoryDefinition cat LEFT JOIN SubCategoryDefinition sub ON cat.CATEGORYID=sub.CATEGORYID
Build version: 8.2.0 Build 8207
Database: MSSQL
Thanks.
Can you provide the query to display only Active (in use) Category, Sub-category and Item?
Found this somewhere in the forums but it lists ALL of them.
SELECT cat.CategoryName "Category" , sub.NAME "Subcategory",(SELECT STUFF((SELECT NAME + CHAR(10) FROM ItemDefinition item where sub.SUBCATEGORYID=Item.SUBCATEGORYID
order by 1 FOR XML PATH ('')), 1, 0, '')) "Item" FROM CategoryDefinition cat LEFT JOIN SubCategoryDefinition sub ON cat.CATEGORYID=sub.CATEGORYID
Build version: 8.2.0 Build 8207
Database: MSSQL
Thanks.