Reset Personal Notification - using webReport schedule

Sun_Livelink_Admin_(sunmic01admin_-_(deleted))

LL 9.5 sp1 wtih WebReports 3.5.0. I have scheduled a web report to execute once a week to reset personal notification for a group of users using a sql update.As the update sql does not display rows affected, how do I map to a subreport or another livereport to display all the users whose notifications were reset ?? Oracle procedures is not an option for now.

Lee_Butler

Message from Lee Butler via eLinkCan you not do it the other way round?E.g. list the users you want to perform updates on in the mainWebReport. Have this do an export of some sort (e.g. email) so that youknow who was updated. In the row section of the WebReport, call a subWebReport for each user you want to update.Thanks,Lee. -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Freitag, 21. September 2007 19:27To: eLink RecipientSubject: Reset Personal Notification - using webReport scheduleReset Personal Notification - using webReport schedulePosted by Valluri, Seetha on 09/21/2007 01:24 PMLL 9.5 sp1 wtih WebReports 3.5.0. I have scheduled a web report to execute once a week to reset personalnotification for a group of users using a sql update.As the update sql does not display rows affected, how do I map to asubreport or another livereport to display all the users whosenotifications were reset ?? Oracle procedures is not an option for now.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/Livelink_LiveReports_DiscussionLivelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.