Way to list files associated with a category

Rees_Williams

We have a historic list of categories which needs tidying up. I am unable to delete several categories because they are in use.What's the best way to list fiiles which use a particular category ?Has a solution to this ever been posted ?Kevin

Bhupinder_Singh

Message from Bhupinder Singh via eLinkThe notes I wrote below on the topic should be of help.- Bhupinder------------------------------------------------------------------------- Bhupinder Singh, B.Math., B.Ed. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------------------------- How do I delete a category that is in use?In order to delete a category in Livelink 9, you need to ensure that no objects are using that category. Livelink will not allow thedeletion of a category currently in use. What we want is a way of locating a list of objects that are using a specific category. Thefollowing LiveReport is a preliminary solution, although it has a limitation which is described below:Select distinct %1 from dtree, llattrdata a, catregionmap m Where dtree.dataid = a.id and dtree.versionnum = a.vernum and a.defid = m.catid and m.catname = 'put the exact category name here' Order By dtree.nameIn which %1 is Report Fields and the report format is set to AutoLiveReport.The limitation on the above report is that there is a special case it does not detect: when an older version of a document has thecategory being located by the LiveReport. For example:- Suppose we have 2 categories: Cat A and Cat B- The LiveReport is configured to located object with Cat A- A document called "Doc with Cat A" is added and assigned Cat A- The LiveReport works and locates the document.- A version is added to "Doc with Cat A", but Cat B is assigned to the new version (Cat A is removed from that version).- Now the document "Doc with Cat A" has 2 versions: Version 2 - with Cat B Version 1 - with Cat A- The LiveReport no longer picks up the document in its results.Here's a LiveReport that gets all versions:Select distinct %1, v.version From dtree, dversdata v, llattrdata a, catregionmap m Where dtree.dataid = v.docid and dtree.dataid = a.id and v.version = a.vernum and a.defid = m.catid and m.catname = 'Can we delete this 2nd Category' Order By dtree.name-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, April 30, 2004 12:12 PMTo: eLink RecipientSubject: Way to list files associated with a categoryWay to list files associated with a categoryPosted by Bennett, Kevin on 04/30/2004 12:09 PMWe have a historic list of categories which needs tidying up. I am unable to delete several categories because they are in use.What's the best way to list fiiles which use a particular category? Has a solution to this ever been posted ?Kevin[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe