Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000098
Table Type: System
Table Name: API Webhook Notification Aggr
Database Table Name: API Webhook Notification Aggr
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 API Webhook Notification Aggr can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[API Webhook Notification Aggr]Show/hide an example select of all columns by name
SELECT
[ID]
,[Subscription ID]
,[Created By User SID]
,[Entity Key Value]
,[Last Modified Date Time]
,[Change Type]
,[Attempt No_]
,[Sending Scheduled Date Time]
,[Entity ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[API Webhook Notification Aggr]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[API Webhook Notification Aggr] AS [API Webhook Notification Aggr]
LEFT JOIN
[External Event Subscription] AS [External Event Subscription]
ON
[API Webhook Notification Aggr].[Subscription Id] = [External Event Subscription].[ID]
LEFT JOIN
[User] AS [User]
ON
[API Webhook Notification Aggr].[Created By User SID] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[API Webhook Notification Aggr].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[API Webhook Notification Aggr].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in API Webhook Notification Aggr table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | ID   | ID | Normal | GUID | 16 | ID | uniqueidentifier |
| 2 | Subscription ID | Subscription ID | Normal | Text | 150 | Subscription ID | nvarchar(300) |
Key to join to the External Event Subscription table.Show/hide example querySELECT
[API Webhook Notification Aggr].[Subscription ID]
,[External Event Subscription].[ID]
FROM
[API Webhook Notification Aggr] AS [API Webhook Notification Aggr]
LEFT JOIN
[External Event Subscription] AS [External Event Subscription]
ON
[API Webhook Notification Aggr].[Subscription ID] = [External Event Subscription].[ID] | |||||||
| 3 | Created By User SID | Created By User SID | Normal | GUID | 16 | Created By User SID | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[API Webhook Notification Aggr].[Created By User SID]
,[User].[User Security ID]
FROM
[API Webhook Notification Aggr] AS [API Webhook Notification Aggr]
LEFT JOIN
[User] AS [User]
ON
[API Webhook Notification Aggr].[Created By User SID] = [User].[User Security ID] | |||||||
| 4 | Entity Key Value | Entity Key Value | Normal | Text | 250 | Entity Key Value | nvarchar(500) |
| 5 | Last Modified Date Time | Last Modified Date Time | Normal | DateTime | 8 | Last Modified Date Time | datetime |
| 6 | Change Type | Change Type | Normal | Option | 4 | Change Type | int |
Available options are:
| |||||||
| 7 | Attempt No. | Attempt No. | Normal | Integer | 4 | Attempt No_ | int |
| 8 | Sending Scheduled Date Time | Sending Scheduled Date Time | Normal | DateTime | 8 | Sending Scheduled Date Time | datetime |
| 9 | Entity ID | Entity ID | Normal | GUID | 16 | Entity ID | uniqueidentifier |
| 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
[API Webhook Notification Aggr].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[API Webhook Notification Aggr] AS [API Webhook Notification Aggr]
LEFT JOIN
[User] AS [User]
ON
[API Webhook Notification Aggr].[$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
[API Webhook Notification Aggr].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[API Webhook Notification Aggr] AS [API Webhook Notification Aggr]
LEFT JOIN
[User] AS [User]
ON
[API Webhook Notification Aggr].[$systemModifiedBy] = [User].[User Security ID] | |||||||