Export Category,subcategory, item
This report is used to export the tree view. This report helps to import category,subcategory and item in other applications. Modify and import in the applications.
SELECT CategoryDefinition.CATEGORYNAME "Category Name", SubCategoryDefinition.NAME "Sub Category Name", ItemDefinition.NAME"Item Name" FROM CategoryDefinition LEFT JOIN SubCategoryDefinition ON SubCategoryDefinition.CATEGORYID=CategoryDefinition.CATEGORYID LEFT JOIN ItemDefinition ON ItemDefinition.SUBCATEGORYID = SubCategoryDefinition.SUBCATEGORYID ORDER BY 1,2,3