11-20-2014 05:25 AM
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
11-21-2014 08:54 AM
Jose,
You should consider joining the Insurance Vogue. It's a really active group that could benefit from your membership.
08-27-2021 12:11 PM
This is very useful query, populate an AutoFill with Itemnum and NumberPages, then build a workflow that populates a Page Count keyword with the AutoFill. This really should come out of the box, it's easy and there are tons of posts out where people are trying to figure out a way to show Page Count in search results.
SELECT
Itemnum,
CASE
WHEN SUM(numberpages) > '1'
THEN SUM(numberpages)
ELSE numberpages
END
AS numberpages
FROM [Nautilus].[hsi].[itemdatapage]
WHERE Itemnum = @primary
GROUP BY Itemnum, numberpages;
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.