Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1170
Table Type: Company
Table Name: User Task
Database Table Name: CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how User Task can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[ID]
,[Title]
,[Created By]
,[Created DateTime]
,[Assigned To]
,[Completed By]
,[Completed DateTime]
,[Due DateTime]
,[Percent Complete]
,[Start DateTime]
,[Priority]
,[Description]
,[Object Type]
,[Object ID]
,[Parent ID]
,[User Task Group Assigned To]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in User Task table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | ID  | int |
| 3 | Title | nvarchar(500) |
| 4 | Created By | uniqueidentifier |
| 5 | Created DateTime | datetime |
| 6 | Assigned To | uniqueidentifier |
| 7 | Completed By | uniqueidentifier |
| 8 | Completed DateTime | datetime |
| 9 | Due DateTime | datetime |
| 10 | Percent Complete | int |
| 11 | Start DateTime | datetime |
| 12 | Priority | int |
| 13 | Description | image |
| 14 | Object Type | int |
| 15 | Object ID | int |
| 16 | Parent ID | int |
| 17 | User Task Group Assigned To | nvarchar(40) |
| 18 | $systemId | uniqueidentifier |
| 19 | $systemCreatedAt | datetime |
| 20 | $systemCreatedBy | uniqueidentifier |
| 21 | $systemModifiedAt | datetime |
| 22 | $systemModifiedBy | uniqueidentifier |