Create a Livereport all new version

Hi,

Does someone can help me to create a livereport for count new version of document ?

I have oracle system.

maybe we can use try with tjis example :

"select count(dtree.dataid) "count" from DTree where dtree.dataid in (select dt1.dataid from dtree dt1 start with dt1.dataid=1340501 connect by prior dt1.dataid=dt1.parentid) and Dtree.subtype = 144 and dtree.createdate between %1 and %2"

It's for calculate new docs from a start directory.

Thanks,

Jd.

Find more posts tagged with

Comments

Lindsay_Davies

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

Hi Julien

What problem do you have with your statement?

It would appear to work, although it is more complicated than necessary.

You do not need to have a nested select, although if you wanted to join another table you may need that.

Was the problem that your input parameters were not valid?

Here is a simplified version where I have used two different ways of specifying a date as literals.

First a literal 'short date' which happens to be the default format on my Oracle install.

Second the current system date/time.

select count(*) from DTree where subtype = 144 and createdate between '01-AUG-10' and sysdate start with dataid=1340501 connect by prior dataid=parentid

If you use 'user inputs', choose a type of Date and they will be User Input 1 and User Input 2 respectively.

This will only show newly created document items.

If you want to see the count of those document items where one or more versions were added (created) between the two dates, you will need to use your Tree walking DataID list as a nested select in a query against the DVersData table, as follows.

select count(distinct(docid)) from dversdata where docid in ( select dataid from DTree where subtype = 144 start with dataid=1340501 connect by prior dataid=parentid ) and vercdate between %1 and %2

Hope this is the sort of thing that you need.

Good luck

Lindsay

Open Text UK

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2011 August 17, Wed 15:41
To: eLink Recipient
Subject: Create a Livereport all new version

Create a Livereport all new version

Posted by julien.discours.actifsolution@axa.fr (Discours, Julien) On 2011/08/17 10:36

Hi, Does someone can help me to create a livereport for count new version of document ? I have oracle system. maybe we can use try with tjis example : "select count(dtree.dataid) "count" from DTree where dtree.dataid in (select dt1.dataid from dtree dt1 start with dt1.dataid=1340501 connect by prior dt1.dataid=dt1.parentid) and Dtree.subtype = 144 and dtree.createdate between %1 and %2" It's for calculate new docs from a start directory. Thanks, Jd.

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Livelink Server:	knowledge-wlweb01