Creating a Document Export Query with Configurable Joins

To create a document export query with Configurable Joins, you will:

    1. Create a query on the Document base and configure the required settings.
    2. Add exports and filters as needed.
    3. Configure the document export format.

Creating a Query on the Document Base

  1. From the main navigation, select Queries / Reports.
  2. Click New Query.
  3. Select New Query. Configure the following settings:
    • Type: Configurable Joins
    • Category: Related
    • Base: Document
  4. Click Save. The query summary page appears. 

Configure_New_Query_Settings.png

  
  1. On the right of the query summary page, select Edit Properties and configure the following settings:
    • Limit Rows: 5000
      • There is a strict limit of 5,000 documents per query execution. Ensure that this setting is configured with a value of 5,000 or less.
    • Execution Options: Retrieve only the new records since the query was last run
    • Fetch Behavior: Preserve where clause on fetch if required by one or more filters.
    • Queue: None (default)
      • The queue setting is incompatible with a document export. Do not adjust this setting.
    • Secondary Key: Copy and paste the following:

      doc__JID_.[stream]
  2. Click Save.

Edit Properties Settings - Secondary Key.png

Standard Exports

Among others, the exports pdf:xml and pdf:file are available from the Document base as Direct Exports (as they were in the Document Export (Application) base).

Exports_-_pdf-xml__pdf-file.png

  Important!

 

Adding these exports to a query on the Document base will prepend the export names with "Document. "

To function as a document export query, you must remove the prepended "Document " text. Click Rename Exports and remove this text before proceeding.

Rename_Exports.png

Replacing custom SQL with Subquery Exports

If you used Custom SQL to customize the pdf:xml or pdf:file exports, you can rebuild and customize these exports using Subquery Exports

Configuring the Document Export Format

Regardless of whether you intend to download the documents manually or export them on a schedule, configuring the Schedule Export settings is required. These settings define the format of the downloaded files. Follow the instructions in the Scheduling Document Exports article to complete this step.

Was this article helpful?
1 out of 3 found this helpful