Which table for possible attribute values?

I am trying to find where the possible values of a specific attribute are stored in LL 9.0.CATREGIONMAP - Cat Names / Att NamesLLATTRDATA = Actual Attribute valuesBut if I have an text popup attribute with three possible values, where are those three stored?

Find more posts tagged with

Comments

eLink User

Message from Alex Kowalenko via eLinkFull attribute definitions including valid popup values are stored in theLLAttrBlobData table as segments of an associative data structure. Thistable is not designed to be queried by SQL commands. The LLAttrData andCatRegionMap tables are extracts from the more complete "blob" informationand are used for SQL and LiveReport purposes.-alex------Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Thursday, August 30, 2001 12:34To: eLink RecipientSubject: Which table for possible attribute values?Which table for possible attribute values?Posted by beauliec on 08/30/2001 12:31 PMI am trying to find where the possible values of a specific attribute arestored in LL 9.0.CATREGIONMAP - Cat Names / Att NamesLLATTRDATA = Actual Attribute valuesBut if I have an text popup attribute with three possible values, where arethose three stored?[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

eLink User

Message from Alex Kowalenko via eLinkMy earlier answer was misleading - full attribute DATA are stored inLLAttrBlobData. Attribute DEFINITIONS, including popups, are stored as"documents", with versions using internal or external storage. You canselect from DTree for SubType 131 to see all Attribute Categories in adatabase. Each Attribute Category will have one or more versions ofdefinitions stored as documents. An example of such a document is attached.It's a binary representation of the associative data structure that holdsthe definitions.-alex------Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Thursday, August 30, 2001 21:17To: eLink RecipientSubject: RE Which table for possible attribute values?RE Which table for possible attribute values?Posted by eLink on 08/30/2001 09:17 PMMessage from Alex Kowalenko via eLinkFull attribute definitions including valid popup values are stored in theLLAttrBlobData table as segments of an associative data structure. Thistable is not designed to be queried by SQL commands. The LLAttrData andCatRegionMap tables are extracts from the more complete "blob" informationand are used for SQL and LiveReport purposes.-alex------Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Thursday, August 30, 2001 12:34To: eLink RecipientSubject: Which table for possible attribute values?Which table for possible attribute values?Posted by beauliec on 08/30/2001 12:31 PMI am trying to find where the possible values of a specific attribute arestored in LL 9.0.CATREGIONMAP - Cat Names / Att NamesLLATTRDATA = Actual Attribute valuesBut if I have an text popup attribute with three possible values, where arethose three stored?[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[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Which table for possible attribute values?https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2582569&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Nethaji_Narasimalu

Can you confirm whether you think that it is impossible to write a Live Report that would query actual values fromLLAttrBlobDate? What would be the other way of gettingLiveReport to display items (news items in my case) containing specific values from popup.I hope that you can share your thoughts on that.Regards,Edward DudetskyEdward.Dudetsky@UK.BritanniaAirways.com

eLink User

Message from Alex Kowalenko via eLinkYou would query values from LLAttrData rather than LLAttrBlobData.-----Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Friday, May 03, 2002 05:43To: eLink RecipientSubject: Valid popup values for LiveReportsValid popup values for LiveReportsPosted by BRITANNIAAdmin on 05/03/2002 05:41 AMCan you confirm whether you think that it is impossible to write a LiveReport that would query actual values fromLLAttrBlobDate? What would be the other way of gettingLiveReport to display items (news items in my case)containing specific values from popup.I hope that you can share your thoughts on that.Regards,Edward DudetskyEdward.Dudetsky@UK.BritanniaAirways.com[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Which table for possible attribute values?https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2582569&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Nethaji_Narasimalu

Thanks for this. OK on that basis I believe that I would have to do a simple joint using two tables DTree and LLAttrData. As currentlyI am quering DTree getting all the recent notices for thelast week running the following -select * from DTree where (DateEffective>%1) and (DateEffective<%2) and %3 and %4 order by DateEffective descParam %1: LastWeek StartParam %2: TodayEndParam %3: FilterNewsParam %4: FilterPermissionsI am displaying two additional fields - DateEffective andDateExpiration and now I would have to do a join to display the value 'ADM' from LLAttrDataSELECT ValStrFROM LLAttrDataWHERE (ValStr LIKE 'ADM')Any ideas how to run this join best?Best Regards,Edward Dudetsky

eLink User

Message from Sean M Alderman via eLinkYou should be able to join the dtree.dataid to the llattrdata.id field,but you also must specify the attribute version, to ensure you only getone hit off each dataid. To do that you'll need to check to make surethat llattrdata.defvernum = dtree.versionnum where dtree.dataid =llattrdata.defidThe version checking can probably be done in a sub query, like -..... where .... and llattrdata.defvernum = (select versionnum fromdtree where dataid = )Does that make sense?On Tue, 2002-05-07 at 10:59, eLink Discussion: Livelink LiveReportsDiscussion wrote:> Valid popup values for LiveReports > Posted by BRITANNIAAdmin on 05/07/2002 10:56 AM> > Thanks for this. > > OK on that basis I believe that I would have to do a simple joint using two tables DTree and LLAttrData. As currently> I am quering DTree getting all the recent notices for the> last week running the following -> > select * from DTree where (DateEffective>%1) and (DateEffective<%2) and %3 and %4 > order by DateEffective desc> > Param %1: LastWeek Start> Param %2: TodayEnd> Param %3: FilterNews> Param %4: FilterPermissions> > I am displaying two additional fields - DateEffective and> DateExpiration and now I would have to do a join to display > the value 'ADM' from LLAttrData> > SELECT ValStr> FROM LLAttrData> WHERE (ValStr LIKE 'ADM')> > Any ideas how to run this join best?> > Best Regards,> > > Edward Dudetsky> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: Which table for possible attribute values?> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2582569&objAction=view> > 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."

eLink User

Message from Alex Kowalenko via eLinkThis Oracle SQL will find one specific attribute value:select DTree.*, a.ValStr "Attribute Value" from DTree, LLAttrData a where DTree.DataID = a.ID and /* Attributes for this DTree item */ DTree.VersionNum = a.VerNum and /* Latest version */ a.EntryNum = 1 and /* First attribute value */ a.DefID = nnn and /* nnn is the Category Definition ID */ a.AttrID = n and /* n is the Attribute ID */ (DTree.DateEffective>%1) and (DTree.DateEffective<%2) and %3 and %4 order by Dtree.DateEffective descAdd this Where clause to get a specific text attribute value: a.ValStr = 'ADM'For performance reasons it's best to hardcode the "nnn" and "n" IDs. You canget them from the CatRegionMap table. Or, if you are using Oracle, importthe two attached LiveReports to get a view of all your Category andAttribute properties.-alex------Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Tuesday, May 07, 2002 11:22To: eLink RecipientSubject: Re Valid popup values for LiveReportsRe Valid popup values for LiveReportsPosted by eLink on 05/07/2002 11:22 AMMessage from Sean M Alderman <sean.m.alderman@grc.nasa.gov> via eLinkYou should be able to join the dtree.dataid to the llattrdata.id field,but you also must specify the attribute version, to ensure you only getone hit off each dataid. To do that you'll need to check to make surethat llattrdata.defvernum = dtree.versionnum where dtree.dataid =llattrdata.defidThe version checking can probably be done in a sub query, like -..... where .... and llattrdata.defvernum = (select versionnum fromdtree where dataid = )Does that make sense?On Tue, 2002-05-07 at 10:59, eLink Discussion: Livelink LiveReportsDiscussion wrote:> Valid popup values for LiveReports> Posted by BRITANNIAAdmin on 05/07/2002 10:56 AM>> Thanks for this.>> OK on that basis I believe that I would have to do a simple joint usingtwo tables DTree and LLAttrData. As currently> I am quering DTree getting all the recent notices for the> last week running the following ->> select * from DTree where (DateEffective>%1) and (DateEffective<%2) and %3and %4> order by DateEffective desc>> Param %1: LastWeek Start> Param %2: TodayEnd> Param %3: FilterNews> Param %4: FilterPermissions>> I am displaying two additional fields - DateEffective and> DateExpiration and now I would have to do a join to display> the value 'ADM' from LLAttrData>> SELECT ValStr> FROM LLAttrData> WHERE (ValStr LIKE 'ADM')>> Any ideas how to run this join best?>> Best Regards,>>> Edward Dudetsky>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Which table for possible attribute values?>https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2582569&objAction=view>> 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."[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Which table for possible attribute values?https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2582569&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Nethaji_Narasimalu

Alex,Thanks very much for this. The only problems is that we have SQL Server 2K here therefore the adjustments willhave to be made from your Oracle SQL.Plus the other thing is that I am trying to get the news items from a specific channel, but I guess that I can limit my query to a node by parsing DataID=211559 andgetting the items from that parent in DTree?...I hope that is clear, please give me your views.Kind regards,Edward Dudetsky