DIM Categories

From IMSMA Wiki
Revision as of 14:19, 12 February 2014 by Alnaucler (talk | contribs)
Jump to navigation Jump to search

Number of DIM categories should be at least 52

SELECT
Count(category.category_guid)
FROM
Category

Note: This query is in 5.x format

Number of Task and WorkItem categories should be at least 5

SELECT
category.pojo_parent,
category.name_translation_key
FROM
category
WHERE
category.pojo_parent =  'TASK' OR
category.pojo_parent =  'WORK_ITEM'
ORDER BY
category.pojo_parent ASC,
category.name_translation_key ASC

Note: This query is in 5.x format