Number of documents added per day

I would like to create a LiveReport that returns the amount of docs added per a specific day. Any thoughts on the SQL??

Find more posts tagged with

Comments

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

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

Something like this ought to work:

select * from dtree where createdate = %1 and %2

... where %1 is either a user input date field or one of the date system parameters, and

... where %2 is the Filter Documents system parameter.

Hope that helps,

Marie Lindsay

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, June 24, 2002 1:31 PM
To: eLink Recipient
Subject: Number of documents added per day

Number of documents added per day Posted by PfizerDevTeam (Developers, Pfizer) on 06/24/2002 02:26 PM

I would like to create a LiveReport that returns the amount of docs added per a specific day. Any thoughts on the SQL??