WorkerJourneyTasksquestionnaireResponsesquestionResponsesquestionResponseAttachments
WorkerJourneyTasksquestionnaireResponsesquestionResponsesquestionResponseAttachments
Columns
| Name | Type | Description |
| WorkerJourneyTasksWorkerJourneyTaskId [KEY] | Long | Unique identifier of the journey task. |
| QuestionnaireresponsesQuestionnaireResponseId [KEY] | Long | Unique identifier for the questionnaire response. |
| QuestionresponsesQuestionResponseId [KEY] | Long | Unique identifier for the question response. |
| AttachedDocumentId [KEY] | Long | Unique identifier of the attached document. |
| LastUpdateDate | Datetime | Date on which the attachment was last updated. |
| LastUpdatedBy | String | User who last updated the attachment. |
| DatatypeCode | String | Attachment type supported for the question. Only the attachment type, FILE, is supported. |
| FileName | String | Name of the attachment file. |
| DmFolderPath | String | Path of the folder. |
| DmDocumentId | String | Surrogate identifier of the document attached to the questionnaire. |
| DmVersionNumber | String | Version number of the attachment. |
| Url | String | URL of a web page attachment. |
| CategoryName | String | Category name of the attachment. This is a read-only attribute. |
| UserName | String | User name of the person who uploaded the attachment. |
| Uri | String | URI of the attachment. This is a read-only attribute. |
| FileUrl | String | File URL of the attachment. |
| UploadedText | String | Text uploaded in the attachment. |
| UploadedFileContentType | String | Content type of the uploaded file. This is a read-only attribute. |
| UploadedFileLength | Long | Size of the uploaded file. This is a read-only attribute. |
| UploadedFileName | String | Name of the uploaded file. This is a read-only attribute. |
| ContentRepositoryFileShared | Bool | Indicates whether the file can be shared. The default value is false and it's the only supported value. |
| Title | String | Title of the attachment. |
| Description | String | Description of the attachment. |
| ErrorStatusCode | String | Error status code of the attachment. |
| ErrorStatusMessage | String | Error status message of the attachment. |
| CreatedBy | String | User who created the attachment. |
| CreationDate | Datetime | Date on which the attachment was created. |
| FileContents | String | File contents of the attachment. |
| ExpirationDate | Datetime | Expiration date of the attachment. This is a read-only attribute. |
| LastUpdatedByUserName | String | Name of the user who last updated the attachment record. |
| CreatedByUserName | String | User name of the user who created the attachment. |
| AsyncTrackerId | String | Attribute provided exclusively for the Attachment UI components to assist in uploading files. |
| FileWebImage | String | The base64 encoded image of the file displayed in .png format if the source is a convertible image. |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CategoryFilter | String | CategoryFilter |
| Facets | String | Facets |
| RequiredFilter | String | RequiredFilter |
| SearchTerms | String | SearchTerms |
| StatusFilter | String | StatusFilter |
| WorkerJourneyTaskId | Long | WorkerJourneyTaskId |
| Finder | String | finder |