Community

How to Find Page Count for Certain Client?

Avatar
Written by ElliotG
  • 1

Hi Everyone,

I'm trying to find the page count for a client but am having trouble. When I search in SQL under:

SELECT * FROM [ABBYY_FC12].[dbo].[Batch] where Name LIKE ('%ClientName%') and CreationDate > '2020-10-01 00:00:00.000' order by Id;

I don't get all the batches.  I feel like these are deleted when the information is exported, is that correct?

When I search the admin station, I can't search in detail on the batchtype, where I have 5 clients in 1 batch type.

How can I find the certain pages per batch type queried by the batchname?

Thanks,

0

Comments

1 comment

Sort by Date Votes
  • Avatar
    Scott Chau

    using the SQL query would work but I suspect the issue the issue is that you are setting the batch to delete after export.  You might need to run your report before that deletion or have that service to grab that data before its deleted.

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post