Custom Query display Number of pages per document

[Todd_Priest]

I have a customer that is looking for a way to run a Custom Query and display the number of pages for each of the documents. Is there any way to do this. Custom SQL query?

Thanks

[Kevin_Cole]

You can do this with image files (TIFFs) that are committed as one-image-per-page documents.  In that case the number of pages indicated in the itemdatapage table is accurate.  Some multi-paged TIFFs may also have good page counts.  

[Eric_Beavers]

Another community member posted some ideas for a SQL query here:

https://www.onbase.com/community/onbase_product_communities/reporting_modules/report_services_produc...

There is also a post about storing page counts for use in autofills:

https://www.onbase.com/community/technical_communities/tech/f/10784/p/7768/11544.aspx#11544

[Drew_Hargrave]

@Joe Pineda @Seth Yantiss could I get a copy of this Unity Script? We would like to do this same thing. Contact me at ahargrave@arvest.com. 

@James Baker 

[Seth_Yantiss]

Todd,

I wrote a Unity Script that adds the page count to a keyword called "Page Count", then added that keyword to the autoname string of certain document types.

Then I added these documents to a workflow queue to process the script against them.

Cheers,
Seth