DIM Categories: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre>SELECT | Number of DIM categories should be at least 52 | ||
<pre> | |||
SELECT | |||
Count(category.category_guid) | Count(category.category_guid) | ||
FROM | FROM | ||
Category | Category | ||
</pre> | |||
Note: This query is in 5.x format | |||
Number of Task and WorkItem categories should be at least 5 | |||
<pre> | |||
SELECT | SELECT | ||
category.pojo_parent, | category.pojo_parent, | ||
| Line 18: | Line 22: | ||
category.name_translation_key ASC | category.name_translation_key ASC | ||
</pre> | </pre> | ||
Note: This query is in 5.x format | |||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | |||
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