DIM Categories: Difference between revisions
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