CAL Test Result – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCAL Test Result

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/130405

Table Type: Company

Table Name: CAL Test Result
Database Table Name: CRONUS UK Ltd_$CAL Test Result$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 130405

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 CAL Test Result can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$CAL Test Result$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[Test Run No_]
   ,[Codeunit ID]
   ,[Codeunit Name]
   ,[Function Name]
   ,[Platform]
   ,[Result]
   ,[Restore]
   ,[Execution Time]
   ,[Error Code]
   ,[Error Message]
   ,[File]
   ,[Call Stack]
   ,[User ID]
   ,[Start Time]
   ,[Finish Time]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$CAL Test Result$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$CAL Test Result$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CAL Test Result]
LEFT JOIN
   [User] AS [User]
      ON
         [CAL Test Result].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [CAL Test Result].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in CAL Test Result table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Integer	4	No_	int
2	Test Run No.	Test Run No.	Normal	Integer	4	Test Run No_	int
3	Codeunit ID	Codeunit ID	Normal	Integer	4	Codeunit ID	int
4	Codeunit Name	Codeunit Name	Normal	Text	30	Codeunit Name	nvarchar(60)
5	Function Name	Function Name	Normal	Text	128	Function Name	nvarchar(256)
6	Platform	Platform	Normal	Option	4	Platform	int
	Available options are: “Classic” “ServiceTier”
7	Result	Result	Normal	Option	4	Result	int
	Available options are: “Passed” “Failed” “Inconclusive” “Incomplete”
8	Restore	Restore	Normal	Boolean	4	Restore	tinyint
9	Execution Time	Execution Time	Normal	Duration	8	Execution Time	bigint
10	Error Code	Error Code	Normal	Text	250	Error Code	nvarchar(500)
11	Error Message	Error Message	Normal	Text	250	Error Message	nvarchar(500)
12	File	File	Normal	Text	250	File	nvarchar(500)
14	Call Stack	Call Stack	Normal	BLOB	8	Call Stack	image
15	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
16	Start Time	Start Time	Normal	DateTime	8	Start Time	datetime
17	Finish Time	Finish Time	Normal	DateTime	8	Finish Time	datetime
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [CAL Test Result].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$CAL Test Result$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [CAL Test Result] LEFT JOIN [User] AS [User] ON [CAL Test Result].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables CCAL Test Result

Show/hide an example select of all columns

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in CAL Test Result table

Show/hide example query

Leave a Reply Cancel reply