Dealing w/ v.9's Cats and Attrs...

Herb_Schilling_(x-nasalewisuser4_-_(deleted))

Greetings, I've been upgrading one of our customizations to version 9. This mod is a special folder item, which adds columns to the normal display to show various category information of the docs in the folder.So, I have the new schema for v.9 and it seems that the LLAttrData table has several type specific fields at the end of it to store the value of the attribute.Has anyone found a good way to determine which value field the value is in?Also, there is a field called LLAttrData.DefID, which seems to have a specific number to represent the category the attributes belong to. Does this number tie into another table with the definition for the category? There doesn't seem to be a link anymore between the category name and it's attribute definitions.If anyone can shed some light on this new structure, it would be a serious help to my mental health.Thanks.

Find more posts tagged with

Comments

Robert_Krystal_(calgaryuser5_-_(deleted))

Hi Sean;I just spent a lot of time trying to figure cats/Attrs schema myself. A definition and a convoluted example of the two category/attribute tables (llattrdata, llattrblobdata) can be found in the Release notes for V. 9 on page 30 (see attachment). It doesn't however show the catregionmap table which maps attributes to categories. It is defined as:? CatID integer - foreign key to dtree.dataid for category template? CatName char(248) - name of category? SetName char(248) - name of a set- if defined, names the set this attribute is a part of? AttrName char(248)- name of the attribute? RegionName char(128)-code identifying attribute, in the formatAttr__attributeid, where attributeid links tollattrdata.attridCategories are now stored as a node in the DTree table. The defid column refers to the category dataid from the DTree table.Hope this helps,Greg

eLink User

Message from Sean M Alderman via eLinkI have opened a ticket w/ support on this. The problem is not knowing the Schema. We have obtained the beta v.9 DB Schema document from OT. My problem lies in making an association between a record in LLAttrData and which Attribute of a particular category it contains the value for.I'm using code like this -recArray sqlResultrecord attrValueString sqlStatement = 'Select * from LLAttrData where AttrType <> -18 and 'for node in nodeRec sqlResult = CAPI.Exec(dbConnection, sqlStatement + node.DATAID) for attrValue in sqlResult switch attrValue.attrtype case -1 // This is a string type // If I knew which attribute this string // was for, I'd do this - node..value = attrValue.ValStr // but I can't determine which attrib this value // belongs to. end case -2 // I don't know what this type is, but I'd do // do the same as above for the appropriate type end end endendSo do you see my dilemma? I have tried just matching the value record returned from the LLAttrData sqlStatement with the order in which records are returned from the CatRegionMap table but that didn't work.At 04:56 PM 02/15/2001 -0500, you (eLink Discussion: Development Discussion) wrote:>Content-Type: text/plain; charset=ISO-8859-1>X-MIME-Autoconverted: from 8bit to quoted-printable by opentext.com id QAA31666>>[Attachments exceeded pre-set size limits. Use the links provided to access]>>RE Dealing w/ v.9's Cats and Attrs... >Posted by CalgaryUser5 on 02/15/2001 04:54 PM>>Hi Sean;>>I just spent a lot of time trying to figure cats/Attrs schema myself. A definition and a convoluted example of the two category/attribute tables (llattrdata, llattrblobdata) can be found in the Release notes for V. 9 on page 30 (see attachment). It doesn't however show the catregionmap table which maps attributes to categories. It is defined as:>? CatID integer - foreign key to dtree.dataid for category template>? CatName char(248) - name of category>? SetName char(248) - name of a set- if defined, names the set this attribute is a part of>? AttrName char(248)- name of the attribute>? RegionName char(128)-code identifying attribute, in the format>Attr__attributeid, where attributeid links to>llattrdata.attrid>>Categories are now stored as a node in the DTree table. The defid column refers to the category dataid from the DTree table.>>Hope this helps,>Greg>>[To reply to this thread, use your normal e-mail reply function.]>>============================================================>>Attachment link: Livelink_9[1].0.0_Release_Notes.pdf>https://knowledge.opentext.com/knowledge/livelink.exe/2455889/Livelink_9[1].0.0_Release_Notes.pdf?func=doc.Fetch&nodeid=2455889>>============================================================>>Topic: Dealing w/ v.9's Cats and Attrs...>https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2453509&objAction=view>>Discussion: Development Discussion>https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=view>>Livelink Server:>https://knowledge.opentext.com/knowledge/livelink.exe- Sean M. AldermanVCIM Senior Systems AnalystNASA Glenn Research CenterCleveland, OH 44135(216) 433-2795

eLink User

Message from Sean M Alderman via eLinkWell, I've resolved my problem. After poking around in SQLPlus looking at the CatRegionMap table I've come up with a simple SQL statement which can be used in CAPI.Exec() to return a recArray with attribute Names and Values...select a.AttrName, b.* from CatRegionMap a, LLAttrData b whereb.ID = and RegionName = 'Attr_' || b.DefID || '_' || b.AttrID From there you've got to use a switch to based on the AttrType to pull the right Value, but it's not too difficult.At 09:26 AM 02/16/2001 -0500, you (eLink Discussion: Development Discussion) wrote:>Content-Type: text/plain; charset="iso-8859-1">X-MIME-Autoconverted: from 8bit to quoted-printable by opentext.com id JAA09554>>Re RE Dealing w/ v.9's Cats and Attrs... BBdHRycy4uLiA=>Posted by eLink on 02/16/2001 09:26 AM>>Message from Sean M Alderman via eLink>>I have opened a ticket w/ support on this. The problem is not knowing the Schema. We have obtained the beta v.9 DB Schema document from OT. My problem lies in making an association between a record in LLAttrData and which Attribute of a particular category it contains the value for.>>I'm using code like this ->>recArray sqlResult>record attrValue>String sqlStatement = 'Select * from LLAttrData where AttrType <> -18 and '>>for node in nodeRec> sqlResult = CAPI.Exec(dbConnection, sqlStatement + node.DATAID)> for attrValue in sqlResult> switch attrValue.attrtype> case -1> // This is a string type> // If I knew which attribute this string> // was for, I'd do this -> node..value = attrValue.ValStr> // but I can't determine which attrib this value> // belongs to.> end> case -2> // I don't know what this type is, but I'd do> // do the same as above for the appropriate type> end> end> end>end>>So do you see my dilemma? I have tried just matching the value record returned from the LLAttrData sqlStatement with the order in which records are returned from the CatRegionMap table but that didn't work.>>At 04:56 PM 02/15/2001 -0500, you (eLink Discussion: Development Discussion) wrote:> >Content-Type: text/plain; charset=ISO-8859-1> >X-MIME-Autoconverted: from 8bit to quoted-printable by opentext.com id QAA31666> >> >[Attachments exceeded pre-set size limits. Use the links provided to access]> >> >RE Dealing w/ v.9's Cats and Attrs... > >Posted by CalgaryUser5 on 02/15/2001 04:54 PM> >> >Hi Sean;> >> >I just spent a lot of time trying to figure cats/Attrs schema myself. A definition and a convoluted example of the two category/attribute tables (llattrdata, llattrblobdata) can be found in the Release notes for V. 9 on page 30 (see attachment). It doesn't however show the catregionmap table which maps attributes to categories. It is defined as:> >? CatID integer - foreign key to dtree.dataid for category template> >? CatName char(248) - name of category> >? SetName char(248) - name of a set- if defined, names the set this attribute is a part of> >? AttrName char(248)- name of the attribute> >? RegionName char(128)-code identifying attribute, in the format> >Attr__attributeid, where attributeid links to> >llattrdata.attrid> >> >Categories are now stored as a node in the DTree table. The defid column refers to the category dataid from the DTree table.> >> >Hope this helps,> >Greg> >> >[To reply to this thread, use your normal e-mail reply function.]> >> >============================================================> >> >Attachment link: Livelink_9[1].0.0_Release_Notes.pdf> >https://knowledge.opentext.com/knowledge/livelink.exe/2455889/Livelink_9[1].0.0_Release_Notes.pdf?func=doc.Fetch&nodeid=2455889> >> >============================================================> >> >Topic: Dealing w/ v.9's Cats and Attrs...> >https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2453509&objAction=view> >> >Discussion: Development Discussion> >https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=view> >> >Livelink Server:> >https://knowledge.opentext.com/knowledge/livelink.exe>>>- Sean M. Alderman>VCIM Senior Systems Analyst>NASA Glenn Research Center>Cleveland, OH 44135>(216) 433-2795>>[To reply to this thread, use your normal e-mail reply function.]>>============================================================>>Topic: Dealing w/ v.9's Cats and Attrs...>https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2453509&objAction=view>>Discussion: Development Discussion>https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=view>>Livelink Server:>https://knowledge.opentext.com/knowledge/livelink.exe- Sean M. AldermanVCIM Senior Systems AnalystNASA Glenn Research CenterCleveland, OH 44135(216) 433-2795