Modified documents

Hi allDoes anyone know how I might create a report listing documents modified by a particular user over a particular peiod of time or even all documents modifed by a particular user.ThanksDavid

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

I just put this one together quickly -- seems to work (with an Oracle database), though I recommend you test it yourself: The LiveReport returns documents modified by a user (i.e. any document which had at least one version added to it by a specific user):

LiveReport Title:

Documents modified by a user

SQL:

select * from DTree where DataID in (select distinct DocID from DVersData where owner = %1)

Input Type: User

Prompt for Input: Select a user

Param %1: User Input 1

Report Format: LiveReport

Let me know if that helps you get started...

- 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 08, 2008 10:56 AM
To: eLink Recipient
Subject: Modified documents

Modified documents

Posted by openunivuser2 (Turpie, David) on 08/08/2008 10:52 AM

Hi all

Does anyone know how I might create a report listing documents modified by a particular user over a particular peiod of time or even all documents modifed by a particular user.

Thanks

David

David_Turpie

Thanks BhupinderThis is a great start and I have built on it slightly by adding the modifydate field to display and have it order by modifydateI will pass this back to the user who requested it and see if this helps themThanks againDavid