DIM Categories - Revision history

Alnaucler at 09:37, 9 April 2015

2015-04-09T09:37:52Z

← Older revision		Revision as of 11:37, 9 April 2015
Line 22:		Line 22:
	</pre>		</pre>

	These two have been missing in the table ''category''. Easiest way to add them is copy and paste manually in Navicat.		These two have been missing in the table ''category''. Easiest way to add them is copy and paste manually in Navicat. Make sure that no spaces are accidently added '''before and/or after''' the data when you paste.
	{\| class="wikitable"		{\| class="wikitable"
	! \| category_guid		! width="250"\| category_guid
	! \| categorization_guid		! width="250"\| categorization_guid
	! \| name_translation_key		! width="150"\| name_translation_key
	! \| pojo_parent		! width="100" \| pojo_parent
	! \| sequence_number		! width""100"\| sequence_number
	\|-		\|-
	\| 0a0a-22eb-12c11c93eaa-7b182c09-1-1006		\| 0a0a-22eb-12c11c93eaa-7b182c09-1-1006

Alnaucler at 17:46, 7 April 2015

2015-04-07T17:46:43Z

@@ Line 22: / Line 22: @@
 </pre>
 {{NavBox Upgrade}}
 [[Category:NoPublic]]
 [[Category:SQL Queries]]

Alnaucler at 08:46, 12 July 2014

2014-07-12T08:46:58Z

← Older revision		Revision as of 10:46, 12 July 2014
Line 6:		Line 6:
	Category		Category
	</pre>		</pre>
	~~{{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
Line 22:		Line 21:
	category.name_translation_key ASC		category.name_translation_key ASC
	</pre>		</pre>
	~~{{note\| This query is in 5.x format}}~~

	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Dionysia at 08:32, 13 February 2014

2014-02-13T08:32:13Z

← Older revision		Revision as of 10:32, 13 February 2014
Line 6:		Line 6:
	Category		Category
	</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
Line 23:		Line 22:
	category.name_translation_key ASC		category.name_translation_key ASC
	</pre>		</pre>
	~~Note:~~ This query is in 5.x format		{{note\| This query is in 5.x format}}

			{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 13:19, 12 February 2014

2014-02-12T13:19:41Z

← Older revision		Revision as of 15:19, 12 February 2014
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

Alnaucler at 13:19, 12 February 2014

2014-02-12T13:19:06Z

← Older revision		Revision as of 15:19, 12 February 2014
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]]

Alnaucler at 15:39, 10 February 2014

2014-02-10T15:39:06Z

← Older revision		Revision as of 17:39, 10 February 2014
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]]

Alnaucler: Created page with "SELECT Count(category.category_guid) FROM Category ----------------------------------------------------- SELECT category.pojo_parent, category.name_translation_key FROM cat..."

2014-02-06T18:08:50Z

Created page with "SELECT Count(category.category_guid) FROM Category ----------------------------------------------------- SELECT category.pojo_parent, category.name_translation_key FROM cat..."

New page

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

[[Category:NoPublic]]