Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/870
Table Type: Company
Table Name: Social Listening Setup
Database Table Name: CRONUS UK Ltd_$Social Listening Setup$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 Social Listening Setup can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Social Listening Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Primary Key]
,[Solution ID]
,[Show on Items]
,[Show on Customers]
,[Show on Vendors]
,[Accept License Agreement]
,[Terms of Use URL]
,[Signup URL]
,[Social Listening URL]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Social Listening Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Social Listening Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Social Listening Setup]
LEFT JOIN
[User] AS [User]
ON
[Social Listening Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Social Listening Setup].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Social Listening Setup table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Primary Key  | Primary Key | Normal | Code | 10 | Primary Key | nvarchar(20) |
| 2 | Solution ID  | Solution ID | Normal | Text | 250 | Solution ID | nvarchar(500) |
| 3 | Show on Items | Show on Items | Normal | Boolean | 4 | Show on Items | tinyint |
| 4 | Show on Customers | Show on Customers | Normal | Boolean | 4 | Show on Customers | tinyint |
| 5 | Show on Vendors | Show on Vendors | Normal | Boolean | 4 | Show on Vendors | tinyint |
| 6 | Accept License Agreement | Accept License Agreement | Normal | Boolean | 4 | Accept License Agreement | tinyint |
| 7 | Terms of Use URL | Terms of Use URL | Normal | Text | 250 | Terms of Use URL | nvarchar(500) |
| 8 | Signup URL | Signup URL | Normal | Text | 250 | Signup URL | nvarchar(500) |
| 9 | Social Listening URL | Social Engagement URL | Normal | Text | 250 | Social Listening URL | nvarchar(500) |
| 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 [Social Listening Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Social Listening Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Social Listening Setup] LEFT JOIN [User] AS [User] ON [Social Listening Setup].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |