Docs/Versions a user in a group owns report...

unknown

Message from Sean M. Alderman via eLinkHi All, I'm modifying the stock My Docs/Versions report with the hope ofmaking it usable for a Base Group. I've changed the user input from auser name to a string representing the group name. And the task of thesql is to collect all documents and versions that each user in thespecified group owns, display them using live report format with onemore column specifying the Owner's name (or id), and ordering the listby that name/id.My problem seems to be that with useing the live report format (so I seethe func menu) I can't add an extra column for the owner info. Am Imissing something or is this not possible?Here's the SQL...select kuaf.name, %1 from DTree, dversdata, kuaf where %2 and(DTree.DataID = DVersData.DocID) and (%3) and kuaf.id in (select a.idfrom kuaf a, kuaf b where b.name = %4 and a.groupid = b.id) and(dtree.userid = kuaf.id or dversdata.owner = kuaf.id) order by kuaf.nameWhere %1 = Report Fields, %2 = Filter Documents, %3 = FilterPermissions, and %4 is the user input.Any ideas? Thanks!--Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795fortune: not found

Bhupinder_Singh

Message from Bhupinder Singh via eLinkAre you using the "Display Columns" section at the bottom of the LiveReportedit page? This is where you can define upto 6 additional columns to bedisplayed with the LiveReport format.Hope that helps...- Bhupinder-------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed. Customer SupportOpen Text Corporation Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292------------------------------------------------------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, November 19, 2003 2:21 PMTo: eLink RecipientSubject: Docs/Versions a user in a group owns report...Docs/Versions a user in a group owns report...Posted by eLink on 11/19/2003 02:20 PMMessage from Sean M. Alderman via eLinkHi All, I'm modifying the stock My Docs/Versions report with the hope ofmaking it usable for a Base Group. I've changed the user input from auser name to a string representing the group name. And the task of thesql is to collect all documents and versions that each user in thespecified group owns, display them using live report format with onemore column specifying the Owner's name (or id), and ordering the listby that name/id.My problem seems to be that with useing the live report format (so I seethe func menu) I can't add an extra column for the owner info. Am Imissing something or is this not possible?Here's the SQL...select kuaf.name, %1 from DTree, dversdata, kuaf where %2 and(DTree.DataID = DVersData.DocID) and (%3) and kuaf.id in (select a.idfrom kuaf a, kuaf b where b.name = %4 and a.groupid = b.id) and(dtree.userid = kuaf.id or dversdata.owner = kuaf.id) order by kuaf.nameWhere %1 = Report Fields, %2 = Filter Documents, %3 = FilterPermissions, and %4 is the user input.Any ideas? Thanks!--Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795fortune: not found[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