View this page in the latest version of Appian. Document Record Type Share Share via LinkedIn Reddit Email Copy Link Print On This Page The capabilities described on this page are included in Appian's advanced and premium capability tiers. Usage limits may apply. What is the document record type? Each Appian environment has a Document record type, which lists all documents stored in Appian that are managed by record types. This record type contains fields with relevant document information, like document name, size, and extension type, so you can easily filter, sort, or aggregate on document data in your applications. This page explains the out-of-the-box Document record type and how to use it. You can only make certain modifications to this record type. Note: The Document record type does not capture information about externally-stored documents or documents managed by folders. Scroll or drag to pan · ⌘+/⌘− to zoom · Esc to close Reference the document record type You cannot query the Document record type directly in your applications. Instead, the Document record type is only accessible as a related record type. This allows you to access information about specific documents in your application. For example, the Case Document record type manages documents related to each support case. To query the documents and related information about those documents (like name, description, and extension), you can query the Case Document record type and reference fields from that record type and the related Document record type. 1 2 3 4 5 6 7 8 9 10 11 12 13 a!queryRecordType( recordType: recordType!Case Document, fields: { recordType!Case Document.fields.documentId, ! recordType!Case Document.relationships.documentProperties.fields.name, ! recordType!Case Document.relationships.documentProperties.fields.description, ! recordType!Case Document.relationships.documentProperties.fields.extension, } pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data Fields By default, the Document record type contains the following fields. You cannot edit or remove any Appian-configured record fields, but you can create new custom record fields. Field Data Type Description Id Number (Integer) The unique identifier of the document. name Text The name of the document. description Text The description of the document. size Number (Integer) The size of the document in bytes. createdOn Date and Time The date and time when the document was created in Appian. createdBy Text The user who created the document in Appian. This field is used to create a relationship to the User record type. modifiedOn Date and Time The date and time when a new version of the document was uploaded in Appian. modifiedBy Text The user who uploaded a new version of the document in Appian. extension Text The file extension of the document. folderId Number (Integer) The unique identifier for the document folder. This folder is automatically created by Appian to store documents for the record type. This folder is not accessible from Appian Designer, but it can be referenced in plug-ins and smart services using the a!documentFolderForRecordType() function. folderName Text The name of the document folder. This folder is not accessible from Appian Designer. totalNumberOfVersions Number (Integer) The number of versions of the document uploaded to Appian. url Text The URL to the document, which you can use to preview the document. Relationships By default, the Document record type will have two relationships to the User record type: createdByUser and modifiedByUser. These relationships allow you to access information about the user who created or modified a document. You cannot add other relationships to the Document record type since it cannot be directly queried. Instead, any record type that has a Document field will automatically have a many-to-one relationship to the Document record type, so you can access common information about your documents. By default, the relationship name is documentProperties. Security By default, all users have Viewer permission to the Document record type. Each document in the Document record type inherits the record-level security from the document management record type. For example, if the Case Documents record type has record-level security configured so that only the assigned engineer can see the documents for a case, then that same security is applied to the document properties. This way, the assigned engineer can see the document and its related properties, while unassigned engineers cannot. Sync the record type A sync will automatically occur on the Document record type when a user submits a form or executes a process model that: Creates a new document. Create a new version of a document. Moves a document from one folder to another. Modifies the document properties, like the document name or description. You can also start a manual full sync from the Sync History page or by saving any changes to the record type. Update the Document record type When you upgrade an existing Appian environment to version 25.4, the Document record type displays an alert prompting you to update the record type to take advantage of new features. Updating the record type will add additional fields and relationships to the Document record type so you can see who made changes to your documents and when. This alert will not appear in sites created in 25.4 or later since the Document record type will already include these fields and relationships. To update the Document record type: Open the Document record type. Click UPDATE NOW in the banner located at the top of the record type. The following fields and relationships are added to the data model: Fields: createdBy modifiedOn modifiedBy Relationships: createdByUser modifiedByUser Click SAVE. A full sync will occur on the record type. Feedback Was this page helpful? SHARE FEEDBACK Loading...