Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/7800
Table Type: System
Table Name: MS-Event Emitter Event Codes
Database Table Name:
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 MS-Event Emitter Event Codes can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[]
Show/hide an example select of all columns by name
SELECT
FROM
[]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[] AS [MS-Event Emitter Event Codes]
LEFT JOIN
[User] AS [User]
ON
[MS-Event Emitter Event Codes].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[MS-Event Emitter Event Codes].[SystemModifiedBy] = [User].[User Security ID]