LiveReport to Show Documents Added by User By Date

I am trying to run a report that shows total number of documents added by user in a specific time frame. For example, total number of documents a user added in 2010. I am using the following, but receiving an error as shown below.

Any help appreciated.

select count(*),userid,k.name from dtree d,kuaf k where subtype = 144
and createdate between %1 and %2and d.userid = k.id group by userid,k.name

Error received :


	Content Server Error: Error processing request. [ORA-00911: invalid character - select count(*),userid,k.name from dtree d,kuaf k where subtype = 144and createdate between ? and ?and d.userid = k.id group by userid,k.name]

Find more posts tagged with

Comments

David_Turpie

I am not sure if this will help but in a previous post I got help with a similar request.

Following on from this I now have a report where I am prompted for a user, created from date and created to date (screenshot attached showing the report screen setup).

The SQL code in the report is

select * from DTree where DataID in (select distinct DocID from DVersData where owner = %1) and (CreateDate>%2) and (CreateDate<%3) order by CreateDate Desc

Items created by....jpg

Colin_Schmidt

If that's literally the script, you need to put a -space- between "144and" and "%2and", so that it's "144 and" and "%2 and"

Colin J.

On Thu, Mar 6, 2014 at 12:17 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

LiveReport to Show Documents Added by User By Date Posted bykaren.morley@goodrich.com (Morley, Karen)On 03-06-2014 12:12

I am trying to run a report that shows total number of documents added by user in a specific time frame. For example, total number of documents a user added in 2010. I am using the following, but receiving an error as shown below. Any help appreciated. select count(*),userid,k.name from dtree d,kuaf k where subtype = 144
and createdate between %1 and %2and d.userid = k.id group by userid,k.name Error received :
Content Server Error: Error processing request.
[ORA-00911: invalid character - select count(*),userid,k.name from dtree d,kuaf k where subtype = 144and createdate between ? and ?and d.userid = k.id group by userid,k.name]

[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

Karen_Morley

Thank you. This is great for one user and I can use this. I was able to run ths for one user and see all the specific documents this person added in a timeframe (I am using subtype of 31067 which is a contract file).

I am still trying to find a way that I can get something similar or have the items counted for all users in one report. Ultimately want to see that UserA added 100 documents in 2010 and UserB added 45 documents in 2010, etc.