Test Method Line

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

Table Type: Company

Table Name: Test Method Line
Database Table Name: CRONUS UK Ltd_$Test Method Line$23de40a6-dfe8-4f80-80db-d70f83ce8caf

Table Number: 0

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 Test Method Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Test Method Line$23de40a6-dfe8-4f80-80db-d70f83ce8caf]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Test Suite]
   ,[Line No_]
   ,[Line Type]
   ,[Test Codeunit]
   ,[Name]
   ,[Function]
   ,[Run]
   ,[Result]
   ,[Start Time]
   ,[Finish Time]
   ,[Level]
   ,[Error Message Preview]
   ,[Error Code]
   ,[Error Message]
   ,[Error Call Stack]
   ,[Skip Logging Results]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Test Method Line$23de40a6-dfe8-4f80-80db-d70f83ce8caf]

Show/hide columns in Test Method Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Test Suite Primary Key Searchnvarchar(20)
3Line No_ Primary Key Searchint
4Line Type Searchint
5Test Codeunit Searchint
6Name Searchnvarchar(256)
7Function Searchnvarchar(256)
8Run Searchtinyint
9Result Searchint
10Start Time Searchdatetime
11Finish Time Searchdatetime
12Level Searchint
13Error Message Preview Searchnvarchar(4096)
14Error Code Searchnvarchar(60)
15Error Message Searchimage
16Error Call Stack Searchimage
17Skip Logging Results Searchtinyint
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 *