User Task

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

Table Number: 1170

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 IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchint
3Title Searchnvarchar(500)
4Created By Searchuniqueidentifier
5Created DateTime Searchdatetime
6Assigned To Searchuniqueidentifier
7Completed By Searchuniqueidentifier
8Completed DateTime Searchdatetime
9Due DateTime Searchdatetime
10Percent Complete Searchint
11Start DateTime Searchdatetime
12Priority Searchint
13Description Searchimage
14Object Type Searchint
15Object ID Searchint
16Parent ID Searchint
17User Task Group Assigned To Searchnvarchar(40)
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *