LiveReport for Category Sets with multivalued attribute

I need to fine tune my LiveReport (code following) to actually show the location of the hard copies. This attribute is in a set and it can be multivalued. I have attached a word doc with a screenprints of the Category, catregion map and an partial output of the LiveReport from the following SQL. We have Oracle 10g and Livelink 9.7.1. Any help would be appreciated. We do NOT have WebReports.SELECT a.dataid, a.subtype, a.gif, a.permid, a.reserved, a.reservedby, g.valstr as "Doctype", a.name, b.valdate as "Docreview", decode(c.valstr,null,' ',c.valstr) as "Docnum", decode(d.valint,null,0,d.valint) as "Number", e.valstr as "Facility", f.valstr as "Dept", (select ' ' from dual) as "Empty" from dtree a, llattrdata b, llattrdata c, llattrdata d, llattrdata e, llattrdata f, llattrdata g where a.dataid = b.id and a.versionnum = b.vernum and b.defid = 862314 and b.attrid=10 and a.dataid = c.id and a.versionnum = c.vernum and c.defid = 862314 and c.attrid=12 and a.dataid = d.id and a.versionnum = d.vernum and d.defid = 862314 and d.attrid=26 and a.dataid = e.id and a.versionnum = e.vernum and e.defid = 862314 and e.attrid=6 and a.dataid = f.id and a.versionnum = f.vernum and f.defid = 862314 and f.attrid=5 and a.dataid = g.id and a.versionnum = g.vernum and g.defid = 862314 and g.attrid=13 and a.subtype = 144 and e.valstr = 'Fresno' and d.valint > 0 ORDER BY "Dept"

Find more posts tagged with

Comments

Jean-Philippe_Martin

Message from <Martin.Jean-Philippe@hydro.qc.ca> via eLink

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

You should find a query that do what you want in this message :

https://knowledge.opentext.com/knowledge/llisapi.dll/fetch/-2249677/17683278/17684920/17686798/17686370/Difference_in_attributes_values_for_a_folder.html?nodeid=17686371&vernum=-2

Just go to the end of the file and take the last query.

De : eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Envoyé : mardi 28 septembre 2010 18:37
À : eLink Recipient
Objet : LiveReport for Category Sets with multivalued attribute

LiveReport for Category Sets with multivalued attribute Posted by mary.corona@ejgallo.com (Corona, Mary) on 2010/09/28 18:32

I need to fine tune my LiveReport (code following) to actually show the location of the hard copies. This attribute is in a set and it can be multivalued. I have attached a word doc with a screenprints of the Category, catregion map and an partial output of the LiveReport from the following SQL. We have Oracle 10g and Livelink 9.7.1. Any help would be appreciated. We do NOT have WebReports.

SELECT a.dataid, a.subtype, a.gif, a.permid, a.reserved, a.reservedby, g.valstr as "Doctype", a.name, b.valdate as "Docreview", decode(c.valstr,null,' ',c.valstr) as "Docnum", decode(d.valint,null,0,d.valint) as "Number", e.valstr as "Facility", f.valstr as "Dept", (select ' ' from dual) as "Empty" from dtree a, llattrdata b, llattrdata c, llattrdata d, llattrdata e, llattrdata f, llattrdata g where a.dataid = b.id and a.versionnum = b.vernum and b.defid = 862314 and b.attrid=10 and a.dataid = c.id and a.versionnum = c.vernum and c.defid = 862314 and c.attrid=12 and a.dataid = d.id and a.versionnum = d.vernum and d.defid = 862314 and d.attrid=26 and a.dataid = e.id and a.versionnum = e.vernum and e.defid = 862314 and e.attrid=6 and a.dataid = f.id and a.versionnum = f.vernum and f.defid = 862314 and f.attrid=5 and a.dataid = g.id and a.versionnum = g.vernum and g.defid = 862314 and g.attrid=13 and a.subtyp! e = 144 and e.valstr = 'Fresno' and d.valint > 0 ORDER BY "Dept"