Query to show Category, Sub category and Item (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) PGSQL & MSSQL: Excute the below query under Report > New Report > Query Report > Copy, Paste the below and Run the query. SELECT CategoryDefinition.CATEGORYNAME "Category Name", ...