DIM Categories: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 7: Line 7:
</pre>
</pre>
Note: This query is in 5.x format
Note: This query is in 5.x format


Number of Task and WorkItem categories should be at least 5
Number of Task and WorkItem categories should be at least 5

Revision as of 14:19, 12 February 2014

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