Message from David Slimmon via eLinkGood morning,This one is not an especially complicated LiveReport, but I've added it tothe collection anyway...LR0025 - How can I display a LiveReport showing all users subscribed toeLink for a specific discussion?
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2073344&objAction=browse&sort=nameSELECT DISTINCT A.Name, A.MailAddress, A.Title, B.Kuaf_Id, B.ObjectIdFROM Kuaf A, ElinkSubscription BWHERE B.ObjectId=XXXXAND A.Id = B.Kuaf_ID* Where XXXX is the value for the b.ObjectID of the discussion you areinterested in reporting on. ObjectId in theElinkSubscription table maps to the DataId of the discussion in the DTreetable.As it stands, this one requires the you already know the Id value of thediscussion in question. It could certainly be made to be a little morecomplicated, but it's a nice starting place for those of you looking toreport on who has subscribed themselves to your discussions.Cheers,Dave___________________________________________O P E N T E X T C O R P O R A T I O NDavid Slimmon, M.L.I.S.Ottawa, Canada
https://knowledge.opentext.comdslimmon@opentext.com
