07-21-2016 02:14 PM
A user asked for a report for a sweep queue of how many documents and pages are *originally* coming into OnBase. There are 3 queues that average about 8000 documents but when I use the numberofdocuments field in the archivedqueue table, 2 of the 3 show zero documents. I modeled it after the "Scheduled Scan Queue Sweep Process" SQL code where I am summing up the detail:
FROM hsi.scheduledprocess sched JOIN hsi.archivedqueue b ON sched.prockey = b.queuenum
JOIN hsi.registeredusers r ON sched.registernum = r.registernum
WHERE b.datestarted @DateRange
AND (r.registernum = @RegisterNum)
AND (sched.schedprocnum = @SchedProcNum)
ORDER BY b.batchnum
I also noticed that the totalpages sums are way too high and for two of the three where the numberofdocuments sum out to zero. Is this the wrong approach?
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.