Read completed jobs in database
Reading completed jobs
When a job has completed processing, the following columns are updated:
Column | Type | Value | Description |
|---|
processed | Integer | 1 | Indicates processing status of the job. 1 = completed |
processedDate | datetime | processed time | The time at which the job was processed |
severityCode | Integer | 1 or 3 | 1 = successful, 3 = error during processing |
statusCode | varchar | 6-digit number | Status code "000000" for success, any other value means error |
statusMessage | varchar | Error message | "Success" for success, otherwise a description of the error |
mimeType | varchar | Output type | The mime type of the output, or null in case of error. (Technically this is the value of metadata "interformng.mimeType" at the end of the workflow) |
resultFile | varchar | Filename | The output filename specified in the workflow, or null if none was set (typically only used in case of file system output). |
pdfData | blob | Output document | The output document that was saved to the database using the "to database" component, or null if no output was saved to the database. |
The metadata rows for the job will also have been updated. Existing rows in the metadata table are updated with the value that the metadata key has at the end of the workflow. New rows are added for metadata keys that were generated during the workflow execution.
Related Articles
From database
A workflow can be initiated by a job record in a database table. Only relational databases are supported. Please notice, that this input only supports the very specific table layout as described in the section, Database configuration, where in input ...
Database connections
If you want InterFormNG2 to connect to a database in order to get input files for processing, then you need to configure the database as below. This section contains these topics: 1.Prerequisite 2.Configuration 3.Connection 4.Setup SQL via library ...
Adding new job records in a database
Adding new job records in a database New job records can be added to the database table by inserting rows in the "job" table. For new jobs, the following columns are used: Column Type Mandatory Value Description processed Integer Yes 0 Indicates ...
To database
This component writes the current workflow payload to a blob column in a database table. You have to specify the name of the database that the output should be saved to. The use of this is primarily intended for workflows that are initiated by the ...
Read from Windows share
You can setup InterFormNG2 to read input files from a folder found via Windows share (Samba network/UNC). For that you need to create a workflow with the input type, Read from Windows share. This can e.g. be useful, if you want to monitor a folder on ...