Casey Wise projects and web archive/sandbox

13Feb/100

dotCMS SQL Query: 2nd level subject hierarchy categories

1
2
3
4
5
6
7
8
9
10
SELECT 
	a.child,
	b.category_name
FROM 
	tree a
	inner join category b
		on a.child = b.inode
		and b.active=1
WHERE 
	parent = 630865
Filed under: code, dotCMS Leave a comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment


No trackbacks yet.