How do I create i Live Report for viewing category data with mulitvalue attributes?

HII'd like to create a Live Report on all documents within a particular category, and I'd like to select all the categories attributes. I've come far, but now I've stumbled on one of the attributes that is multivalued, you can chose up to 5 rows for this attribute that is a Text Field.When I run my Live Report I get 2 rows for the the document that have 2 rows for this attribute - how can I avoid that and get a nicer looking report?Here you can see my test Live Report:select distinct(dtree.dataid), a.valstr "IN", dtree.name "Benämning", b.valstr "utgåva" from dtree, llattrdata a , llattrdata b, where (dtree.dataid=a.id and dtree.versionnum=a.vernum and a.defid=66851 and a.attrid=2) and (dtree.dataid=b.id and dtree.versionnum=b.vernum and b.defid=66851 and b.attrid=30) and dtree.dataid not in (select nodeid from deleteddocs) order by a.valstrThanksNina

Find more posts tagged with

Comments

Chris_Jones

Message from Jones, Christopher L. \(IT\) via eLinkWe built a view in our database that collects DataID and the Max Version number of sub type 144 and use this to query the LL attr data this gives you only the current version attributes.c3.jones@ngc.com-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Monday, March 14, 2005 12:25 PMTo: eLink RecipientSubject: How do I create i Live Report for viewing category data withmulitvalue attributes?How do I create i Live Report for viewing category data with mulitvalue attributes?Posted by Englund, Nina on 03/14/2005 01:24 PMHII'd like to create a Live Report on all documents within a particular category, and I'd like to select all the categories attributes. I've come far, but now I've stumbled on one of the attributes that is multivalued, you can chose up to 5 rows for this attribute that is a Text Field.When I run my Live Report I get 2 rows for the the document that have 2 rows for this attribute - how can I avoid that and get a nicer looking report?Here you can see my test Live Report:select distinct(dtree.dataid), a.valstr "IN", dtree.name "Benämning", b.valstr "utgåva" from dtree, llattrdata a , llattrdata b, where (dtree.dataid=a.id and dtree.versionnum=a.vernum and a.defid=66851 and a.attrid=2) and (dtree.dataid=b.id and dtree.versionnum=b.vernum and b.defid=66851 and b.attrid=30) and dtree.dataid not in (select nodeid from deleteddocs) order by a.valstrThanksNina[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

Nina_Lewau_(sablinadmin_-_(deleted))

Thanks, but I'm not sure we're talking about the same thing. Versions isn't a problem for us, it's the multivalued attributes that's the catch.Look at the attched dump to see what kind of attributs I'm referering to.Thanks/Nina

Lee_Butler_(lbutler_(Delete)_2946657)

Message from Lee Butler <lbutler@opentext.com> via eLink

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

The 3.x release of WebReports has 2 possible solutions to this problem.

Insert a JavaScript array

Using the INSERTJSARRAY feature a WebReport is used to automatically create a JavaScript array for each unique row of data in the LiveReport - except were we have a multi-value. In the case of a multi-value (multiple rows for the same nodeid) the WebReport will populate a second dimension to the array which contains all the values for that same nodeid. The WebReport handles all this for you, all you need to do is create the JavaScript to dump the contents of the 2 dimensional array.

CAT subtag

If you know the structure of the category you are reporting on you can use the CAT subtag. I've pasted a section of the online help below - refer to the 2 rows in red. The first one allows you to dump the entire contents of the multi-value whilst the second one allows you to access the individual elements in case you want to change the order or manipulate the data in some way.

Thanks,
Lee.

-----------------------8<-------------Online help excerpt from 3.x-------------8<---------------------------------

Return information about the Categories and Attributes associated with the returned object ID. This sub-tag supports both attribute sets and multi-value attributes through use of the MV and SET operators.

For Example: [LL_REPTAG=DATAID CAT:<catname>:<attname>:DISPLAY /] will return the attribute value stored in the category <catname> and the attribute <attname> for any attribute type. If <attname> is a multi-value attribute or an attribute set a comma-separated list of values will be returned.

Syntax Description

CAT Will return TRUE/FALSE depending on the presence of one or more categories assigned to the node.

CAT:DISPLAY Will return a string containing a list of semi-colon separated category names assigned to the node. Any category containing mandatory attributes will be suffixed with an exclamation in square brackets - [!].

CAT:MAND Will return TRUE/FALSE depending on whether a category containing a mandatory attribute is assigned to to the node.

CAT:<catname> Will return TRUE/FALSE depending on the presence of the <catname> category.

CAT:<catname>:DISPLAY Will return a string containing a list of semi-colon separated attribute values for the category specified in <catname>. If either attribute sets or multi-value attributes are contained in the category they will be displayed in the following syntax:
'atval1;atval2;[SET3:atval4,atval5,[MV6:atval7,atval8]];atval9'
Here atval1, atval2 & atval9 are regular attribute values. [SET3: represents the start of an attribute set where 3 is the attribute ID of the set (see note). Contained in the attribute set are two regular attributes (atval4 & atval5) and a multi-value attribute, starting [MV6:, with 6 being the attribute ID of the multi-value attribute. The multi-value attribute contains 2 values for attribute 6, these are: atval7 & atval8.

N.B: Attribute ID's can be identified by looking at the browser status bar whilst hovering over the attribute name in the category definition page.

CAT:<catname>:ID Will return the ID of <catname> if the category is present.

CAT:<catname>:<attname> Will return TRUE/FALSE depending on whether an attribute, <attname>, exists with a non-blank value in the category, <catname>. If an attribute set is specified in <attname>, a single entry in any one of the set's attribute values will cause this to return TRUE. If <attname> is a multi-value attribute, a single entry in any one will also cause this to return TRUE. <attname> can also be nested within an attribute set either as a regular attribute or a multi-value attribute.

CAT:<catname>:<attname>:DISPLAY Will return the value in the attribute, <attname>, for the category, <catname>. If <attname> is an attribute set or a multi-value attribute a comma separated list of values will be returned.

CAT:<catname>:<attname>:ID Will return the ID of the attribute, <attname>, for the category, <catname> if it is present. If <attname> exists inside an attribute set, it will be returned if no attribute matching <attname> exists at the top level in the category. If <attname> exists at the top level of the category and within an attribute set of the same category, the attribute ID at the top level (not within the set) will take precedence.

CAT:<catname>:<attname>:<attval> Will return TRUE/FALSE depending on whether an attribute, <attname>, exists with a value equal to <attval> in the category, <catname>. <attname> may be an attribute within an attribute set (including a multi-value), or any element within a multi-value attribute.

CAT:<catname>:MV:<attname>:<n>
Will return TRUE/FALSE for the presence of a specific non-blank element in a multi-value attribute, <attname>, for the category, <catname> at the index location <n>. The value of <n> must be a positive integer between 1 and n where n does not exceed the length of the multi-value attribute. If n exceeds the length of the multi-value attribute, an empty string will be returned.

CAT:<catname>:MV:<attname>:<n>:<attval>
Will return TRUE/FALSE for the presence of <attval> in a multi-value attribute, <attname>, for the category, <catname> at the index location <n>. The value of <n> must be a positive integer between 1 and n where n does not exceed the length of the multi-value attribute.

CAT:<catname>:MV:<attname>:<n>:DISPLAY Will return the value in the multi-value attribute, <attname>, for the category, <catname> at the index location <n> where <n> is a positive integer between 1 and n. The value of <n> must be a positive integer between 1 and n where n does not exceed the length of the multi-value attribute.

CAT:<catname>:MV:<attname>:INDEX:<attval> Will return the first index of the multi-value attribute, <attname>, for the category, <catname> where <attval> is equal to the value contained in the multi-value attribute at index. For example, if <attval> exists in the third element of <attname>, the number 3 will be returned.

CAT:<catname>:SET:<setname>:<attname> Uses the SET operator allowing attribute sets to be explicitly referenced. This example will return TRUE if attribute, <attname> within set, <setname> is non-blank. Only attributes within <setname> can be referenced so if <attname> exists outside the set, it will not be found. If <attname> is a multi-value attribute, TRUE will be returned if any field within it is non-blank.

CAT:<catname>:SET:<setname>:<attname>:DISPLAY Will return the value in the attribute, <attname>, for the category, <catname>, if <attname> is an attribute within <setname>. If <attname> is a multi-value attribute, a comma separated list of the defined values will be returned. If no defined value exists, either in a multi-value attribute, or a standard attribute, an empty list will be returned.

CAT:<catname>:SET:<setname>:<attname>:ID Will return the ID of the attribute <attname> within the set <setname>. If <attname> exists outside <setname> it will not be returned. <attname> can be either a regular or multi-value attribute.

CAT:<catname>:SET:<setname>:<attname>:<attval> Will return TRUE/FALSE depending on whether an attribute, <attname>, exists with a value equal to <attval> in the set, <setname>. If <attname> is a multi-value attribute, all elements will be checked for equality against <attval>, if any match, TRUE will be returned.

CAT:<catname>:SET:<setname>:MV:<attname>:<n> Will return TRUE/FALSE for the presence of a specific non-blank element in a multi-value attribute, <attname>, within a set, for the category, <catname> at the index location <n>. The value of <n> must be a positive integer between 1 and n where n does not exceed the length of the multi-value attribute.

CAT:<catname>:SET:<setname>:MV:<attname>:<n>:<attval> Will return TRUE/FALSE for the presence of <attval> in a multi-value attribute, <attname>, within a set, for the category, <catname> at the index location <n>. The value of <n> must be a positive integer between 1 and n where n does not exceed the length of the multi-value attribute.

CAT:<catname>:SET:<setname>:MV:<attname>:<n>:DISPLAY Will return the value in the multi-value attribute, <attname>, within a set, for the category, <catname> at the index location <n> where <n> is a positive integer between 1 and n. The value of <n> must be a positive integer between 1 and n where n does not exceed the length of the multi-value attribute.

CAT:<catname>:SET:<setname>:MV:<attname>:INDEX:<attval> Will return the first index of the multi-value attribute, <attname>, within a set, for the category, <catname> where <attval> is equal to the value contained in the multi-value attribute at index.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 14 March 2005 19:25
To: eLink Recipient
Subject: How do I create i Live Report for viewing category data with mulitvalue attributes?

How do I create i Live Report for viewing category data with mulitvalue attributes? Posted by SABLINAdmin (Englund, Nina) on 03/14/2005 01:24 PM

HI

I'd like to create a Live Report on all documents within a particular category, and I'd like to select all the categories attributes. I've come far, but now I've stumbled on one of the attributes that is multivalued, you can chose up to 5 rows for this attribute that is a Text Field.

When I run my Live Report I get 2 rows for the the document that have 2 rows for this attribute - how can I avoid that and get a nicer looking report?

Here you can see my test Live Report:

select distinct(dtree.dataid), a.valstr "IN", dtree.name "Benämning", b.valstr "utgåva" from dtree, llattrdata a , llattrdata b, where (dtree.dataid=a.id and dtree.versionnum=a.vernum and a.defid=66851 and a.attrid=2) and (dtree.dataid=b.id and dtree.versionnum=b.vernum and b.defid=66851 and b.attrid=30) and dtree.dataid not in (select nodeid from deleteddocs) order by a.valstr

Thanks
Nina

Orlando_Covault

Hi,

Is it a recent or easer way to archive this in livelink 9.7.1?

Regards,

Orlando Covault