Need To know how i can find a Categories by using an SQL

Carl_Lubertozzi_(carllubertozzi_-_(deleted))

Hi,Would klike to make a SQL query to find a Categories with a Name and get the field in thta with teh data in that can any one help me on this There is a Default query in Livelink Which is like this select ValStr, count(DataID) "Count" from DTree, LLAttrData where ID=DataID and VerNum=VersionNum and AttrID=1 and DefID in (select distinct DataID from DTree,LLAttrData where DefID=DataID and %1) and %2 group by ValStr order by Count(DataID) descBut i ned to find a single categories and the field associated with it.Need to retrieve the below fieldDocument Name ,Process Number, Platform Type , Creation Date, Effective Date, Revision Date, Doc Type, Next Review DatePlease replay on sudarshan.s.chawla@jpmorgan.com

Jeff_Chong_(oxfprowebgroup_-_(deleted))

Not sure exactly what you want your query to retrieve. However, you can get all of your category and attribute IDs through a func=attributes.dump. From there, you should be able to build your query.