Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/130415
Table Type: Company
Table Name: Semi-Manual Test Wizard
Database Table Name: CRONUS UK Ltd_$Semi-Manual Test Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972
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 Semi-Manual Test Wizard can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Semi-Manual Test Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Codeunit number]
,[Codeunit name]
,[Step number]
,[Step heading]
,[Manual detailed steps]
,[Total steps]
,[Skip current step]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Semi-Manual Test Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Semi-Manual Test Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Semi-Manual Test Wizard]
LEFT JOIN
[User] AS [User]
ON
[Semi-Manual Test Wizard].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Semi-Manual Test Wizard].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Semi-Manual Test Wizard table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Codeunit number  | Codeunit number | Normal | Integer | 4 | Codeunit number | int |
| 2 | Codeunit name  | Codeunit name | Normal | Text | 250 | Codeunit name | nvarchar(500) |
| 3 | Step number | Step number | Normal | Integer | 4 | Step number | int |
| 4 | Step heading | Step heading | Normal | Text | 250 | Step heading | nvarchar(500) |
| 5 | Manual detailed steps | Manual detailed steps | Normal | BLOB | 8 | Manual detailed steps | image |
| 6 | Total steps | Total steps | Normal | Integer | 4 | Total steps | int |
| 7 | Skip current step | Skip current step | Normal | Boolean | 4 | Skip current step | tinyint |
| 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 querySELECT
[Semi-Manual Test Wizard].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Semi-Manual Test Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Semi-Manual Test Wizard]
LEFT JOIN
[User] AS [User]
ON
[Semi-Manual Test Wizard].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Semi-Manual Test Wizard].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Semi-Manual Test Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Semi-Manual Test Wizard]
LEFT JOIN
[User] AS [User]
ON
[Semi-Manual Test Wizard].[$systemModifiedBy] = [User].[User Security ID] | |||||||