CAL 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
   [timestamp]
   ,[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 columns in CAL Test Result table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchint
3Test Run No_ Searchint
4Codeunit ID Searchint
5Codeunit Name Searchnvarchar(60)
6Function Name Searchnvarchar(256)
7Platform Searchint
8Result Searchint
9Restore Searchtinyint
10Execution Time Searchbigint
11Error Code Searchnvarchar(500)
12Error Message Searchnvarchar(500)
13File Searchnvarchar(500)
14Call Stack Searchimage
15User ID Searchnvarchar(100)
16Start Time Searchdatetime
17Finish Time Searchdatetime
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 *