Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000242
Table Type: System
Table Name: External Event Notification
Database Table Name: External Event Notification
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 External Event Notification can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[External Event Notification]Show/hide an example select of all columns by name
SELECT
[Log Entry Id]
,[Subscription Id]
,[Status]
,[Last Retry Date Time]
,[Retry Count]
,[Not Before]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[External Event Notification]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[External Event Notification] AS [External Event Notification]
LEFT JOIN
[External Event Log Entry] AS [External Event Log Entry]
ON
[External Event Notification].[Log Entry Id] = [External Event Log Entry].[ID]
LEFT JOIN
[External Event Subscription] AS [External Event Subscription]
ON
[External Event Notification].[Subscription Id] = [External Event Subscription].[ID]
LEFT JOIN
[User] AS [User]
ON
[External Event Notification].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[External Event Notification].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in External Event Notification table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Log Entry Id   | Log Entry Id | Normal | Integer | 4 | Log Entry Id | int |
Key to join to the External Event Log Entry table.Show/hide example querySELECT
[External Event Notification].[Log Entry Id]
,[External Event Log Entry].[ID]
FROM
[External Event Notification] AS [External Event Notification]
LEFT JOIN
[External Event Log Entry] AS [External Event Log Entry]
ON
[External Event Notification].[Log Entry Id] = [External Event Log Entry].[ID] | |||||||
| 2 | Subscription Id | Subscription Id | Normal | GUID | 16 | Subscription Id | uniqueidentifier |
Key to join to the External Event Subscription table.Show/hide example querySELECT
[External Event Notification].[Subscription Id]
,[External Event Subscription].[ID]
FROM
[External Event Notification] AS [External Event Notification]
LEFT JOIN
[External Event Subscription] AS [External Event Subscription]
ON
[External Event Notification].[Subscription Id] = [External Event Subscription].[ID] | |||||||
| 3 | Status | Status | Normal | Option | 4 | Status | int |
Available options are:
| |||||||
| 4 | Last Retry Date Time | Last Retry Date Time | Normal | DateTime | 8 | Last Retry Date Time | datetime |
| 5 | Retry Count | Retry Count | Normal | Integer | 4 | Retry Count | int |
| 6 | Not Before | Not Before | Normal | DateTime | 8 | Not Before | datetime |
| 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
[External Event Notification].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[External Event Notification] AS [External Event Notification]
LEFT JOIN
[User] AS [User]
ON
[External Event Notification].[$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
[External Event Notification].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[External Event Notification] AS [External Event Notification]
LEFT JOIN
[User] AS [User]
ON
[External Event Notification].[$systemModifiedBy] = [User].[User Security ID] | |||||||