DIM Categories: Difference between revisions
Jump to navigation
Jump to search
Created page with "SELECT Count(category.category_guid) FROM Category ----------------------------------------------------- SELECT category.pojo_parent, category.name_translation_key FROM cat..." |
No edit summary |
||
| Line 1: | Line 1: | ||
SELECT | <pre>SELECT | ||
Count(category.category_guid) | Count(category.category_guid) | ||
FROM | FROM | ||
| Line 9: | Line 9: | ||
category.pojo_parent, | category.pojo_parent, | ||
category.name_translation_key | category.name_translation_key | ||
FROM | FROM | ||
category | category | ||
WHERE | WHERE | ||
category.pojo_parent = 'TASK' OR | category.pojo_parent = 'TASK' OR | ||
category.pojo_parent = 'WORK_ITEM' | category.pojo_parent = 'WORK_ITEM' | ||
ORDER BY | ORDER BY | ||
category.pojo_parent ASC, | category.pojo_parent ASC, | ||
category.name_translation_key ASC | category.name_translation_key ASC | ||
</pre> | |||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
Revision as of 16:39, 10 February 2014
SELECT Count(category.category_guid) FROM Category ----------------------------------------------------- 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