How to find out what objects are using an category

Hi:I'm currently trying to delete a category from the Categories Volume. I get an error message saying it cannot be deleted because it is used by other objects. Can someone tell me how I can find out the objs that are using it so I can delete them and then in turn delete the category?

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Let me know if this posting helps:

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3444678&objAction=view&show=2

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: Thursday, November 13, 2008 4:17 PM
To: eLink Recipient
Subject: How to find out what objects are using an category

How to find out what objects are using an category

Posted by kristyshen (Shen, Kristy) on 11/13/2008 04:15 PM

Hi:

I'm currently trying to delete a category from the Categories Volume. I get an error message saying it cannot be deleted because it is used by other objects.

Can someone tell me how I can find out the objs that are using it so I can delete them and then in turn delete the category?

Benjamin_Shapiro_(benshapiro_-_(deleted))

Hi Kristy,Bhupinder posted an *excellent* message about this. I've even bookmarked it because of how useful it is.https://knowledge.opentext.com/knowledge/llisapi.dll/open/14663400It entails writing a LiveReport and will give you exactly the information you need!Cheers,Ben

Kristy_Shen

Hi Bhupinder:Thanks for your response. I ran your sql but got no results. Still I cannot delete the "Correspondence" category. Here's the sql I ran:Select * 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 = 'Correspondence' Order By dtree.name

Kristy_Shen

Strange...I took the ID for the records in the llattrdata table that have defid=[catid of the Correspondence' category] and queried for them in dtree. There did not exist in dtree but does exist in the dauditnew table.

Darren_Hodder

Hi Kristy,Just an idea, I'm not sure how many items you have using that category, but you can create a LiveReport using the following SQL code:SELECT DISTINCT id FROM LLAttrData WHERE DefID = This will give you a list of unique ids of items in LiveLink using that Category. You could then join that with dtree to find out parentIDs and names for each item if you like, or if you have a tool such as WebReports you can use that LiveReport as a data source and display the node names and links to each item?s container, then for each item remove the category (or create a more advanced report that does this for you).Hope that helps!Darren HodderResonateKT Supportdhodder@resonatekt.comwww.resonatekt.com

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Try using Livelink advanced search (Tools menu, Search) to see if you can find objects that have the category associated with them. Once you are on the advanced search page, click the "Categories" link in the left pane, select the "Correspondence" category, and provide an asterisk in the first attribute field.

- Bhupinder

From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: Friday, November 14, 2008 9:15 AM
To: eLink Recipient
Subject: RE How to find out what objects are using an category

RE How to find out what objects are using an category		Posted by kristyshen (Shen, Kristy) on 11/14/2008 09:13 AM
In reply to: RE How to find out what objects are using an category		Posted by bsingh (Singh, Bhupinder) on 11/13/2008 04:37 PM

Hi Bhupinder:

Thanks for your response. I ran your sql but got no results. Still I cannot delete the "Correspondence" category.

Here's the sql I ran:

Select *
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 = 'Correspondence'
Order By
dtree.name

Kristy_Shen

Hi Bhupinder:I tried your suggestion, but when I left the search text blank and selected the category I wanted I get the following error message. Am I missing something?Livelink Error: Error in search broker [You have either not specified any search criterion at all, or one of your Livelink Query Language statements is incorrect. Edit the query by clicking an option in at least one list and/or correcting the statements that appear in the fields. ]

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Did you put an asterisk in the first (or any) attribute field once the attributes within the category showed up on the Advanced Search page?

- Bhupinder

From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: Friday, November 14, 2008 10:09 AM
To: eLink Recipient
Subject: RE How to find out what objects are using an category

RE How to find out what objects are using an category		Posted by kristyshen (Shen, Kristy) on 11/14/2008 10:04 AM
In reply to: RE RE How to find out what objects are using an category		Posted by bsingh (Singh, Bhupinder) on 11/14/2008 09:41 AM

Hi Bhupinder:

I tried your suggestion, but when I left the search text blank and selected the category I wanted I get the following error message.
Am I missing something?

Livelink Error: Error in search broker
[You have either not specified any search criterion at all, or one of your Livelink Query Language statements is incorrect. Edit the query by clicking an option in at least one list and/or correcting the statements that appear in the fields. ]

Claudia_Meyer

Message from Christopher Meyer <cmeyer@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Do you have the Livelink API (LAPI; part of the Enterprise Server SDK)? Another solution is to write a small LAPI application to identify the nodes and remove the category from them. This might be the quickest solution if the category has been applied to many items in the system.

From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: Thursday, November 13, 2008 22:17
To: eLink Recipient
Subject: How to find out what objects are using an category

How to find out what objects are using an category

Posted by kristyshen (Shen, Kristy) on 11/13/2008 04:15 PM

Hi:

I'm currently trying to delete a category from the Categories Volume. I get an error message saying it cannot be deleted because it is used by other objects.

Can someone tell me how I can find out the objs that are using it so I can delete them and then in turn delete the category?

sıɹɥɔ

That SQL assumes the items you are looking for are Documents (or a type that has versions associated with it). If you want to find any type of item you'll want to remove references to the "dversdata" table (and its alias "v") from the SQL.-chris

Kristy_Shen

When I put in asterisk in the category fields and do search I get:Your search did not return any items.Suggestions: Make sure all words are spelled correctly Try different keywords Try more general keywords

Kristy_Shen

Thanks for your reply Chris. However, even when I just did a query for the id in the llattrdata table for the record that had the defid of my category, I did not find this id in the dtree table.

Darren_Hodder

Hi Kristy,I'm curious if you tried the reply to you post here: https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=15423050&objAction=view&show=2I had a similar issue an dthis worked for my needs.Cheers,Darren