Folder Creation -SQL Statement for Oracle Db

Hello.,

Wonder if you could help do you happen to have a sql for running a report to find the Creation date of folders and Created by , Modified information.

Thanks in advance.

Regards

Shiva

Find more posts tagged with

Comments

Bhupinder_Singh

Re: “Wonder if you could help do you happen to have a sql for running a report to find the Creation date of folders and Created by , Modified information.”

A basic report could be:

select name, createdate, createdby, modifydate from DTree where subtype=0

To get the name of the “createdby” user instead of the numeric ID, you can try this:

Select a.name, a.createdate, b.firstname, b.lastname, a. modifydate from DTree a, KUAF b where a.subtype=0 and a.createdby=b.ID

Always run LiveReports on a test system first whenever possible.

- Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.

Systems Administrator, Cloud Services
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

Shiva_Rajan

Hello Bhupinder ,

THanks for your assistance, is it possible to run it to a specific Parent folder and sub folder for specific period with user prompts enabled?

Regards

Shiva

Bhupinder_Singh

RE: “…possible to run it to a specific Parent folder and sub folder for specific period with user prompts enabled?”

Using the basic report as a starting point:

select name, createdate, createdby, modifydate from DTree where subtype=0

…we could modify it to be:

select name, createdate, createdby, modifydate from DTree where subtype=0 and ParentID in (%1, %2) and createdate >=%3 and createdate <=%4

Inputs --

#1: Type: Container -- Prompt: Select the Parent Folder

#2: Type: Container -- Prompt: Select the Sub Folder

#3: Type: Date -- Prompt: Enter Start Date

#4: Type: Date -- Prompt: Enter End Date

Param%1: User Input 1

Param%2: User Input 2

Param%3: User Input 3

Param%4: User Input 4

Format: AutoLiveReport

- Bhupinder

Shiva_Rajan

ThanksBhupinder for your help.

Regards

Shiva

From: eLink Entry: Content Server LiveReportsForum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 01 October 2012 18:37
To: eLink Recipient
Subject: Folder Creation -SQL Statement for Oracle Db

Folder Creation -SQL Statement for Oracle Db

Posted by bsingh@opentext.com (Singh, Bhupinder) On 10-01-2012 13:32

RE: “…possible to run it to a specific Parent folder and sub folder for specific period with user prompts enabled?”

Using the basic report as a starting point:

select name, createdate, createdby, modifydate from DTree where subtype=0

…we could modify it to be:

select name, createdate, createdby, modifydate from DTree where subtype=0 and ParentID in (%1, %2) and createdate >=%3 and createdate <=%4

Inputs --

#1: Type: Container -- Prompt: Select the Parent Folder

#2: Type: Container -- Prompt: Select the Sub Folder

#3: Type: Date -- Prompt: Enter Start Date

#4: Type: Date -- Prompt: Enter End Date

Param%1: User Input 1

Param%2: User Input 2

Param%3: User Input 3

Param%4: User Input 4

Format: AutoLiveReport

- Bhupinder

[To post a comment, use the normal reply function]
Topic:	Folder Creation -SQL Statement for Oracle Db
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

***********************************************************************************

The contents of the e-mail and any transmitted files are confidential and intended solely for the use of the individual or entity to whom they are addressed. Transport for London hereby exclude any warranty and any liability as to the quality or accuracy of the contents of this email and any attached transmitted files. If you are not the intended recipient be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited., If you have received this email in error please notify postmaster@tfl.gov.uk., This email has been sent from Transport for London, or from one of the companies within its control within the meaning of Part V of the Local Government and Housing Act 1989. Further details about TfL and its subsidiary companies can be found at http://www.tfl.gov.uk/ourcompany, This footnote also confirms that this email message has been swept for the presence of computer viruses.

***********************************************************************************