Live report to find where a category is applied

Hello

I hope someone can help. I need to run a live report to find where a category is applied across the enterprise. I know the data id of the category but if anyone could help with the SQL statement it would be appreciated.

Thanks

Elizabeth.

Find more posts tagged with

Comments

Chris Meyer

Try this:

select DTree.* from DTree, LLAttrData where AttrID=1 and DTree.DataID=LLAttrData.ID AND DTree.VersionNum=LLAttrData.VerNum

This will work with non versioned items and versioned items where the last version uses the category.