Query to return active Category/SubCategory/Item
Hi guys,
I've got a Custom Query that returns the Category, SubCategory and Item names from ServiceDesk Plus but I can't find a way to filter it so that only ACTIVE records show.
I've observed that each related table has an 'IsDeleted' column, but in all records (active and inactive) that field appears to be empty.
My query follows - would appreciate assistance on filtering to show just the active records:
SELECT cd.CATEGORYNAME "Category", scd.NAME "Sub Category", id.NAME "Item" FROM CategoryDefinition as cd
LEFT OUTER JOIN SubCategoryDefinition as scd ON cd.CATEGORYID = scd.CATEGORYID
LEFT OUTER JOIN ItemDefinition as id ON scd.SUBCATEGORYID = id.SUBCATEGORYID
WHERE cd.IsDeleted IS NULL