Number of scanned documents
Counts scanned documents by provider over a period of time
Number of scanned documents.txt
—
Plain Text,
0Kb
File contents
<report title="Number of scanned documents" description="Counts scanned documents by provider over a period of time " active="1">
<query>
select count(document_no)from document where updatedatetime between
('{start_date} 00:00:00') and ('{finish_date} 23:59:59') and doccreator =
'{provider}' ;
</query>
<param id="start_date" type="date" description="From date"> </param>
<param id="finish_date" type="date" description="To date"> </param>
<param id="provider" type="list" description="Provider number">
<param-query> select provider_no,
concat(last_name,',',first_name,'(',provider_no,')') from provider order by
last_name; </param-query> </param>
</report>
