Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
eLink Subscriptions ...
Cy_Hauptmann_(VISTIN013_(Delete)_2428529)
Hello all,Has anyone created a report to show who is subscribed to a particular Discussion via eLink??Cy Hauptmann
Find more posts tagged with
Comments
eLink User
Message from David Slimmon via eLinkWow...you know what, I think that I have written that!Let me look around and see what I can find. I'll post it to this discussionas soon as I find it :)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.Supervisor - Customer SupportOttawa, Canada
https://knowledge.opentext.comdslimmon@opentext.com-----Original
Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Tuesday, May 29, 2001 1:09 PMTo: eLink RecipientSubject: eLink Subscriptions ...eLink Subscriptions ...Posted by VISTIN013 on 05/29/2001 01:07 PMHello all,Has anyone created a report to show who is subscribed to a particularDiscussion via eLink??Cy Hauptmann[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussion
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink
Server:
https://knowledge.opentext.com/knowledge/livelink.exe
eLink User
Message from David Slimmon via eLinkHi there,This might be a good start. I knew that I'd looked into some of thisbefore. Hope you find it useful or at least a good start: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=nameKind
regards,David___________________________________________O P E N T E X T C O R P O R A T I O NDavid Slimmon, M.L.I.S.Supervisor - Customer SupportOttawa, Canada
https://knowledge.opentext.comdslimmon@opentext.com-----Original
Message-----Hello all,Has anyone created a report to show who is subscribed to a particularDiscussion via eLink??Cy Hauptmann
Cy_Hauptmann_(VISTIN013_(Delete)_2428529)
i typed in that livereport and it doesnt' work for my SQL database and LL 9.0.0.1 I don't see anything wrong with the syntax .. so I confused.
eLink User
Message from David Slimmon via eLinkHi there,I don't think that there shouldn't be anything too weird in the LiveReporton the KC. What happens when you try to run the report? Does it generatean error or no results? You might want to just double-check that youhaven't made any typing mistakes or to verify that no expressions arerunning together where spaces should be. I've tested this report twice nowand it appears to work on Livelink 9.0.x using both MSSQL 7.0 and Oracle8.1.x.But to diagnose the problem a bit, maybe we should start with a preliminaryAuto-LiveReport to see how that goes for you. The following SQL, when addedinto a LiveReport (with the Auto-LiveReport function enabled) will generatea report that shows you the DataIds of all the discussions in your databasethat have eLink Subscribers:1. Lookup DataId for All Discussions with eLink Subscribers:SELECT DISTINCT A.Name, A.DataIdFROM DTree A, ElinkSubscription BWHERE A.SubType=215 AND A.DataID = B.ObjectIdDoes this one work for you? If so, take the result of the report anddetermine the DataId of the discussion you are interested in based itsfriendly name.When I run this report on my system, it generates a table that looks likethis:==================================Name DataId==================================TestDiscussion 13506My results are obviously very short since I only have one discussion in mysystem that has an eLink subscriber. The discussion is called"TestDiscussion" and the DataId for it is '13506'. Your results will bedifferent of course. Once you have determined the DataId of the discussionyou're interested in, you can proceed to the next LiveReport, which was theone from my original mail.2. Lookup Name, MailAddress etc. of Users Subscribed to Discussion ****.SELECT DISTINCT A.Name, A.MailAddress, A.Title, B.Kuaf_Id, B.ObjectIdFROM Kuaf A, ElinkSubscription BWHERE B.ObjectId=13506 AND A.Id = B.Kuaf_IDAs you can see in the last line of this LiveReport, I've added the value of'13506' to the B.ObjectId= argument. This is where you'll need to add theDataId you are interested in finding out about. For me, this query returnsa result of one user (since only 1 user is subscribed to the TestDiscussionon the Livelink install on my laptop). I've attached a screenshot of whatmy Edit LiveReport page looks like so that you can compare it to your own.Remeber to turn on the Auto-LiveReport functionality.Let me know how this goes if you get a chance.Kind regards,Dave-----Original Message-----i typed in that livereport and it doesnt' work for my SQL database and LL9.0.0.1I don't see anything wrong with the syntax .. so I confused.
