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 |