LiveReport for folder creation

Navneet__Kaur

I need to know how to create a LiveReport that will display what folders have been created in a subfolder for a specific timeframe.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Try this:

 

Inputs:

 

Date, with Prompt: Enter start date

 

Date, with Prompt: Enter end date

 

Container, with Prompt: Select a parent folder

 

SQL: select * from dtree where createdate >= %1 and createdate <=%2 and parentid=%3 and subtype=0

 

Param %1: User Input 1

 

Param %2: User Input 2

 

Param %2: User Input 3

 

Format: LiveReport

 

Display Columns:

 

Field: CreateDate

 

Column Title: Date Created

 

Let me know if that helps. Note that the above query does not check for sub-sub-folders within the select parent. It only goes one level deep from the parent.

 

- 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: Monday, May 12, 2008 3:09 PM
To: eLink Recipient
Subject: LiveReport for folder creation

 

LiveReport for folder creation

Posted by lhart@intermune.com (Hart, Lisa) on 05/12/2008 03:05 PM

I need to know how to create a LiveReport that will display what folders have been created in a subfolder for a specific timeframe.