How Do I Count the Number of Pages and Documents in an AppXtender Application?

How Do I Count the Number of Pages and Documents in an AppXtender Application?

The following queries need to be executed on the production AppXtender(AX) SQL Server and it is strongly recommended to make sure you have a database backup before performing any database activities are performed. Also, as we are going to run SQL Count commands, consider the production system impact and perhaps run them outside of business hours.

The AX App Table Structures
All AX apps have an appid which is referenced throughout the database. All the appid is stored in the ae_apps table. The following screenshot is what the AX Demo database looks like:

The above table shows the relationship between the appid and the dtname (the document related information) and the dlname (the document page related information). For example, the AP application has an appid of 101 and the document table is ae_dt101 and the page table is ae_dl101. Therefore to count number of documents and pages you would use the following queries:

Adding Query Conditions 
If you query the document table (ae_dt101 in the above example) you will notice that the column names are generically named as shown below:

Query the ae_adefs table to understand what the column names translate to:

    • Related Articles

    • Viewing Documents in DocuNECT

      Applies to Version: v4.5, v4.6, v4.7 and v4.8 This document provides an overview of the current viewing technology that DocuNECT uses in v4.6. Viewing vs Editing Document management falls into two categories: 1. Collaborative – Documents that are ...
    • User Unable to Login in AppXtender Web

      in AppXtender Web v16.3, if a user logging in receives an error message stating that they have not permissions to an application then the user will need to be deleted and re-added. Note, if the AX audit trail then please create a support case. 
    • AppXtender Web 30 Page Thumbnail Limit

      OpenText Engineering addressed a customer performance use case where large thumbnail counts were impacting the first page render performance.  In doing so they limited maximum thumbnails to be rendered to 30.  This is not ideal for most customers so ...
    • iSubmitQuery in ApplicationXtender v16.3

      The iSubmitQuery interface is still in ApplicationXtender v16.3, however, there is no real documentation. The only documentation is from 2008 and is attached but its basically the same. Enabling the Test Utility In lieu of there being no ...
    • Accessing the AppXtender Doc ID in the Document Manager and Web

      AppXtender assigns a unique document ID (Doc ID) to each document. If you need to review the audit trail for a specific document then you will need the Doc ID, which is not exposed by default. AppXtender Web You will need change the web setting to ...