I want to get a report of documents that are scanned into the "xxx" scanning queue.

[Jenny_Le1]

Hello,

I am first time user onbase running SQL queries, I need some input on how to put this together.

Part 1

I want to get a report of documents that are scanned into the "xxx" scanning queue. What I need to see is how many documents have been scanned for the previous week, broken down per day and per document type and per user.

so far this is what i got but i'm don't think it what suppose to be for above request

select sl.usernum, aq.batchnum, aq.queuename, sl.logdate, aq.batchname,
id.itemtypename, aq.numberdocuments, aq.totaldocuments, aq.totalpages
from hsi.scanninglog sl, hsi.archivedqueue aq, hsi.useraccount, hsi.doctype id
where aq.queuename = 'xxx'
and sl.logdate >=dateadd(day,datediff(day,0,GetDate())- 7,0)

Part 2

We want another report that tells us by day (for the previous week), how many documents went into the "abc" lifecycle, and how many left the "abc" lifecycle.

and for this i got

select wf.statenumto, wf.entrytime, wf.exittime, wf.usernum
from hsi.wflog wf
join hsi.useraccount ua on ua.usernum = wf.usernum
where statenumto = 108
and wf.entrytime >=DATEADD(day,datediff(day,0,GetDate())- 7,0)

greatly appreciate any help

[Nathan_Kumaras3]

Change aq.queuename = 'xxx' to aq.queuenum = 'xxx'

[Jenny_Le1]

Thanks Nathan

[Ansley_Ingram]

Hi Jenny,

If you're new to SQL, I'd recommend working with one of your DBAs to modify the canned report for your needs - especially if you are reporting against your production environment. There is additional information in the Report Services MRG on how the configuration, input parameters, etc. work outside of a need for a solid understanding of SQL and the OnBase database. 

Hope that helps.

Ansley

[Jenny_Le1]

Thanks Ansley

[Jenny_Le1]

I've figured out.