DIM Categories

From IMSMA Wiki
Revision as of 19:08, 6 February 2014 by Alnaucler (talk | contribs) (Created page with "SELECT Count(category.category_guid) FROM Category ----------------------------------------------------- SELECT category.pojo_parent, category.name_translation_key FROM cat...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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