LearnerLearningRecordslearningItemRelatedMaterials
LearnerLearningRecordslearningItemRelatedMaterials
Columns
Name | Type | Description |
LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordslearningItemRelatedMaterials |
AttachedDocumentId [KEY] | Long | AttachedDocumentId of LearnerLearningRecordslearningItemRelatedMaterials |
LastUpdateDate | Datetime | LastUpdateDate of LearnerLearningRecordslearningItemRelatedMaterials |
LastUpdatedBy | String | LastUpdatedBy of LearnerLearningRecordslearningItemRelatedMaterials |
DatatypeCode | String | DatatypeCode of LearnerLearningRecordslearningItemRelatedMaterials |
FileName | String | FileName of LearnerLearningRecordslearningItemRelatedMaterials |
DmFolderPath | String | DmFolderPath of LearnerLearningRecordslearningItemRelatedMaterials |
DmDocumentId | String | DmDocumentId of LearnerLearningRecordslearningItemRelatedMaterials |
DmVersionNumber | String | DmVersionNumber of LearnerLearningRecordslearningItemRelatedMaterials |
Url | String | Url of LearnerLearningRecordslearningItemRelatedMaterials |
CategoryName | String | CategoryName of LearnerLearningRecordslearningItemRelatedMaterials |
UserName | String | UserName of LearnerLearningRecordslearningItemRelatedMaterials |
Uri | String | Uri of LearnerLearningRecordslearningItemRelatedMaterials |
FileUrl | String | FileUrl of LearnerLearningRecordslearningItemRelatedMaterials |
UploadedText | String | UploadedText of LearnerLearningRecordslearningItemRelatedMaterials |
UploadedFileContentType | String | UploadedFileContentType of LearnerLearningRecordslearningItemRelatedMaterials |
UploadedFileLength | Long | UploadedFileLength of LearnerLearningRecordslearningItemRelatedMaterials |
UploadedFileName | String | UploadedFileName of LearnerLearningRecordslearningItemRelatedMaterials |
ContentRepositoryFileShared | Bool | ContentRepositoryFileShared of LearnerLearningRecordslearningItemRelatedMaterials |
Title | String | Title of LearnerLearningRecordslearningItemRelatedMaterials |
Description | String | Description of LearnerLearningRecordslearningItemRelatedMaterials |
ErrorStatusCode | String | ErrorStatusCode of LearnerLearningRecordslearningItemRelatedMaterials |
ErrorStatusMessage | String | ErrorStatusMessage of LearnerLearningRecordslearningItemRelatedMaterials |
CreatedBy | String | CreatedBy of LearnerLearningRecordslearningItemRelatedMaterials |
CreationDate | Datetime | CreationDate of LearnerLearningRecordslearningItemRelatedMaterials |
FileContents | String | FileContents of LearnerLearningRecordslearningItemRelatedMaterials |
ExpirationDate | Datetime | ExpirationDate of LearnerLearningRecordslearningItemRelatedMaterials |
LastUpdatedByUserName | String | LastUpdatedByUserName of LearnerLearningRecordslearningItemRelatedMaterials |
CreatedByUserName | String | CreatedByUserName of LearnerLearningRecordslearningItemRelatedMaterials |
AsyncTrackerId | String | AsyncTrackerId of LearnerLearningRecordslearningItemRelatedMaterials |
FileWebImage | String | FileWebImage of LearnerLearningRecordslearningItemRelatedMaterials |
DownloadInfo | String | DownloadInfo of LearnerLearningRecordslearningItemRelatedMaterials |
SourceId | Long | SourceId of LearnerLearningRecordslearningItemRelatedMaterials |
AttachmentId | Long | AttachmentId of LearnerLearningRecordslearningItemRelatedMaterials |
AttachmentNumber | String | AttachmentNumber of LearnerLearningRecordslearningItemRelatedMaterials |
AttachmentName | String | AttachmentName of LearnerLearningRecordslearningItemRelatedMaterials |
AttachmentType | String | AttachmentType of LearnerLearningRecordslearningItemRelatedMaterials |
AttachmentLink | String | AttachmentLink of LearnerLearningRecordslearningItemRelatedMaterials |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
SysEffectiveDate | String | SysEffectiveDate |
AssignedToId | Long | assignedToId |
AssignerAttributionType | String | assignerAttributionType |
AssignerId | Long | assignerId |
AssignmentRecordId | Long | assignmentRecordId |
DataSecurityPrivilege | String | dataSecurityPrivilege |
Finder | String | finder |
LearnerId | Long | learnerId |
LearningItemId | Long | learningItemId |
LearningItemTitle | String | learningItemTitle |
ManagerId | Long | managerId |