TimeRecordGroupstimeRecordGroupstimeRecordGroups
TimeRecordGroupstimeRecordGroupstimeRecordGroups
Columns
| Name | Type | Description |
| TimeRecordGroupstimeRecordGroupId [KEY] | Long | TimeRecordGroupstimeRecordGroupId of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| TimerecordgroupstimeRecordGroupId [KEY] | Long | TimerecordgroupstimeRecordGroupId of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| TimeRecordGroupId [KEY] | Long | TimeRecordGroupId of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| ParentTimeRecordGroupId | Long | ParentTimeRecordGroupId of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| StartTime | Datetime | StartTime of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| StopTime | Datetime | StopTime of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| StartDate | Date | StartDate of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| StopDate | Date | StopDate of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| GroupType | String | GroupType of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| PersonNumber | String | PersonNumber of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| PersonId | Long | PersonId of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| Comment | String | Comment of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| AssignmentNumber | String | AssignmentNumber of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| TimeRecordGroupVersion | Int | TimeRecordGroupVersion of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| ParentTimeRecordGroupVersion | Int | ParentTimeRecordGroupVersion of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| TotalHours | Double | TotalHours of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
| FavoriteName | String | FavoriteName of TimeRecordGroupstimeRecordGroupstimeRecordGroups |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |