When using a Live Report what are the minimum fiels required from Dtree?

When using a Live Report what are the minimum fiels required from Dtree?I have a requirement to write a Livereport which displays Documents and their attributes. I also require this to be a Live Report so that this can be used to navigate through to these documents. This reports gives me the information I need but does not function as a Live report. What DTREE fields are missing?SELECT dtree.NAME, dtree.dataid, dtree.parentid, MAX (DECODE (llattrdata.attrid, 4, llattrdata.valstr, NULL) ) discipline, MAX (DECODE (llattrdata.attrid, 5, llattrdata.valstr, NULL) ) subject, MAX (DECODE (llattrdata.attrid, 13, llattrdata.valstr, NULL) ) firstlinecomments, MAX (DECODE (attrid, 14, valstr, NULL)) secondlinecomments, llattrdata.ID FROM dtree, llattrdata WHERE dtree.NAME <> 'NWL TLP PLACEHOLDER.pdf' AND dtree.parentid <> 31387892 AND dtree.SUBTYPE = 144 AND dataid = llattrdata.ID AND llattrdata.defid = 25985920 GROUP BY llattrdata.ID, dtree.NAME, dtree.dataid, dtree.parentid

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

From what I recall, you need the name, dataID and subtype columns, but the easiest way is to use a %1 reference ( for example, "select %1, dtree.NAME, dtree.dataid, dtree.parentid..." ) and set "Param %1" on the LiveReport edit page to "Report fields". This will get Livelink to retrieve the columns required for the LiveReport format for you.

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, August 22, 2008 6:50 AM
To: eLink Recipient
Subject: When using a Live Report what are the minimum fiels required from Dtree?

When using a Live Report what are the minimum fiels required from Dtree?

Posted by craigstanley (Stanley, Craig) on 08/22/2008 06:47 AM

When using a Live Report what are the minimum fiels required from Dtree?

I have a requirement to write a Livereport which displays Documents and their attributes. I also require this to be a Live Report so that this can be used to navigate through to these documents.

This reports gives me the information I need but does not function as a Live report. What DTREE fields are missing?

SELECT dtree.NAME, dtree.dataid, dtree.parentid,
MAX (DECODE (llattrdata.attrid, 4, llattrdata.valstr, NULL)
) discipline,
MAX (DECODE (llattrdata.attrid, 5, llattrdata.valstr, NULL)
) subject,
MAX (DECODE (llattrdata.attrid, 13, llattrdata.valstr, NULL)
) firstlinecomments,
MAX (DECODE (attrid, 14, valstr, NULL)) secondlinecomments,
llattrdata.ID
FROM dtree, llattrdata
WHERE dtree.NAME <> 'NWL TLP PLACEHOLDER.pdf'
AND dtree.parentid <> 31387892
AND dtree.SUBTYPE = 144
AND dataid = llattrdata.ID
AND llattrdata.defid = 25985920
GROUP BY llattrdata.ID, dtree.NAME, dtree.dataid, dtree.parentid

Appu_Nair

I once wanted to figure out what ReportFields gets replaced as so I could test the same query with TOAD or SQLplus.After looking thru builder I think I found the code replacing it as%1 Report Fields=DTree.DataID,DTree.Name,DTree.SubType,DTree.GIF,DTree.PermID,DTree.Reserved,DTree.ReservedBy,DTree.ExAtt1,DTree.Major,DTree.VersionNumI have not checked this in a while.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

That's a good idea! I just checked a Livelink 9.7.1 instance, running a report that would fail, like:

select %1 from DTree where you=me

...and the resulting error message reveals the %1 columns as

DTree.DataID, DTree.Name, DTree.SubType, DTree.GIF, DTree.PermID, DTree.Reserved, DTree.ReservedBy, DTree.ExAtt1, DTree.Major, DTree.VersionNum

So, it looks like just using %1 set to "report fields" is the simplest way to go. :-)

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, August 25, 2008 10:26 AM
To: eLink Recipient
Subject: I once wanted to figure out what ReportFields gets replaced as so I could test...

I once wanted to figure out what ReportFields gets replaced as so I could test...		Posted by anair@alitek.com (Nair, Appu) on 08/25/2008 10:24 AM
In reply to: RE When using a Live Report what are the minimum fiels required from Dtree?		Posted by bsingh (Singh, Bhupinder) on 08/25/2008 10:20 AM

I once wanted to figure out what ReportFields gets replaced as so I could test the same query with TOAD or SQLplus.After looking thru builder I think I found the code replacing it as

%1 Report Fields
=DTree.DataID,DTree.Name,DTree.SubType,
DTree.GIF,DTree.PermID,DTree.Reserved,
DTree.ReservedBy,DTree.ExAtt1,
DTree.Major,DTree.VersionNum

I have not checked this in a while.