Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/0
Table Type: Company
Table Name: AL Test Suite
Database Table Name: CRONUS UK Ltd_$AL Test Suite$23de40a6-dfe8-4f80-80db-d70f83ce8caf
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 AL Test Suite can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$AL Test Suite$23de40a6-dfe8-4f80-80db-d70f83ce8caf]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Name]
,[Description]
,[Last Run]
,[Run Type]
,[Test Runner Id]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$AL Test Suite$23de40a6-dfe8-4f80-80db-d70f83ce8caf]Show/hide columns in AL Test Suite table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Name  | nvarchar(20) |
| 3 | Description | nvarchar(60) |
| 4 | Last Run | datetime |
| 5 | Run Type | int |
| 6 | Test Runner Id | int |
| 7 | $systemId | uniqueidentifier |
| 8 | $systemCreatedAt | datetime |
| 9 | $systemCreatedBy | uniqueidentifier |
| 10 | $systemModifiedAt | datetime |
| 11 | $systemModifiedBy | uniqueidentifier |