Output Action SQLAction

This Output Action stores generated documents along with page count, page number of bookmarks and metadata in a SQL database. It is a basic Output Action which is automatically installed with your dox42 Server.

Parameters

Note

The parameter names of the Output Actions are not case-sensitive. All parameter names may contain data fields (exceptions are described in the relevant parameters).

Example: FileName = "Application_<%Citizen.Name%>.pdf"

Parameter	Requirement	Description
`ConnectionString`	mandatory	Defines the full connection string for the database.
`Format`	mandatory	Specifies the file format (.doc, .docx, .pdf, .xls, .xlsx,.jpg, .tiff, etc.) Example:`.doc`
`SpecialFormat`	optional	Specifies a special format (dox42 Server for Documents only): `PDFA1b` `PDFForm`(Form fields are preserved in the PDF).
`SQLStatement`	mandatory	Specifies the SQL Statement, which can be inserted or updated. Refer to Inserting and updating a SQL Statement. Possible codes: `<%Document%>`: the generated document as binary `<%Document.PageCount%>`: total number of pages `<%Document.PageOfBookmark(MyBookmark)%>`: page where the bookmark named “MyBookmark” is found in the document. You can use any name for your bookmarks. `<%Datasource.Datafield%>`: data field values