Reporting on Custom Categories

Where are Custom Categories saved ?? I've tried to query from 'CustomCategories' table in the schema and got the error 'table does not exist'...I need to create reports based on the custom attributes attached to the documents...

Find more posts tagged with

Comments

eLink User

Message from Sean M Alderman via eLinkCategories are now stored in Dtree, with subtype of 131.On Thu, 2002-04-11 at 11:55, eLink Discussion: Livelink LiveReportsDiscussion wrote:> Reporting on Custom Categories> Posted by EquitableUser1 on 04/11/2002 11:51 AM> > Where are Custom Categories saved ?? I've tried to query from 'CustomCategories' table in the schema and got the error 'table does not exist'...> > I need to create reports based on the custom attributes attached to the documents...> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> > -- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795Calling a windowed operating system "Windows" is like naming anautomobile "Wheels."

eDOX_AXA_Financial_(edox_-_(deleted))

thanks Sean. There should be some indication of that in the schema somewhere....

eLink User

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

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

It sounds like you've recently upgraded from v8.x, where there was a table per category, to v9.x, where there is not. In v9.x, there's a table called LLAttrData that stores all custom category data in a format that you can poll with SQL. The bad news is that the schema is not as straightforward as in v8.x. The good news is that v9.x supports some great attribute functionality, such as the ability to add multiple values of an attribute and the ability to have "sets" of attributes. This discussion has a useful posting about this made back in November by Sean Alderman:

https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2628891&objAction=view&show=2

-----Original Message-----
From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of eLink Discussion: Livelink LiveReports Discussion
Sent: Thursday, April 11, 2002 10:56 AM
To: eLink Recipient
Subject: Reporting on Custom Categories

Reporting on Custom Categories Posted by EquitableUser1 (Liang, Peggy) on 04/11/2002 11:51 AM

Where are Custom Categories saved ?? I've tried to query from 'CustomCategories' table in the schema and got the error 'table does not exist'...

I need to create reports based on the custom attributes attached to the documents...