Report on Users created for a range of dates and Report on Documents created on a range of dates

Hi,

Could anyone help me with creating reports on 1) Users created in range of dates and 2) Report on Documents created on a range of date for a given particular folder

Thanks & Regards,

Umashanker.K

Find more posts tagged with

Comments

Agarwal_Gourav

Hi Uma,

For the sceond requirement, please try the following query as liveReport :

Select c.name as DocumentName, to_char(c.CreateDate, 'DD-MM-YYYY') as DocCreateDate from dauditnew a,dtree p, dtree c where a.dataid in ( select d.dataid from dtree d start with(d.dataid=%1)connect by prior d.dataid=d.parentid ) and (a.auditid = 1) and c.parentid=p.dataid and a.dataid=c.dataid and c.subtype=144and c.createdate>%2 and c.createdate<%3

where 1st input is the Container and the rest 2 inputs are dates.

Hope this helps.

Regards,

Gourav

Lori_Himsl

Hi - try this (Oracle DB) with parameter 1 as date (Start Date) and parameter 2 as date (End Date). This will give you non-deleted users. If you want all of them regardless if they're deleted or not then remove the k1.deleted=0.

SELECT k1.LastName, k1.FirstName, d.CreateDate FROM KUAF k1, dtree d where d.dataid=k1.id and (d.createdate BETWEEN %1 and %2) and k1.Type = 0 AND k1.Deleted = 0 ORDER BY 2,1