12-11-2017 03:29 PM
Is there a query that can help me find out how many documents of a particular type have been imported into OnBase?
We have set up a couple of departments up with the OnBase Office integration and I want to run a query that shows me how many documents of the following type are in OnBase: Word, Excel, Powerpoint and Outlook (.msg).
Any assistance is greatly appreciated.
Regards,
-Daniel
12-11-2017 04:05 PM
I have used this in the past:
select COUNT(*), ft.filetypestr
from hsi.itemdatapage idp
join hsi.filetype ft on idp.filetypenum = ft.filetypenum
group by ft.filetypestr
12-11-2017 04:05 PM
I have used this in the past:
select COUNT(*), ft.filetypestr
from hsi.itemdatapage idp
join hsi.filetype ft on idp.filetypenum = ft.filetypenum
group by ft.filetypestr
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.