LiveReport for folder creation

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

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

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.