02-08-2016 12:45 PM
I've got a requirement to report out the qty of docs in a batch processed by the EDI Processor module. Looking at the Database Reporting Guide, I believe that the table, PARSEDQUEUE is the one I'm after, and a couple test queries almost confirm that.
EXCEPT! none of the EDI batches have a parsedqueue.numberdocuments greater than 0.
Am I misunderstanding the purpose of that column?
02-09-2016 12:55 PM
Hi Anthony,
The database column, parsedqueue.numberdocuments, is not a column that is currently in use by any OnBase import processors.
John's solution is correct, but will include the verification report. For a processor like DIP, the index file would also be included in this count.
Thanks for using Community,
Roger
02-08-2016 12:57 PM
I only have 0 in that column too. I'd proably join to the hsi.itemdata table by batchnum, and do a count of the records in hsi.itemdata (grouped by batchnum).
02-09-2016 12:55 PM
Hi Anthony,
The database column, parsedqueue.numberdocuments, is not a column that is currently in use by any OnBase import processors.
John's solution is correct, but will include the verification report. For a processor like DIP, the index file would also be included in this count.
Thanks for using Community,
Roger
03-15-2016 09:35 AM
03-28-2016 10:31 AM
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.