Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000228
Table Type: System
Table Name: Report Settings Override
Database Table Name: Report Settings Override
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 Report Settings Override can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[Report Settings Override]Show/hide an example select of all columns by name
SELECT
[Object ID]
,[Company Name]
,[Timeout]
,[MaxRows]
,[MaxDocuments]
,[Format Language Tag]
,[Language ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[Report Settings Override]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[Report Settings Override] AS [Report Settings Override]
LEFT JOIN
[Company] AS [Company]
ON
[Report Settings Override].[Company Name] = [Company].[Name]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Report Settings Override].[Language ID] = [Language].[Windows Language ID]
LEFT JOIN
[User] AS [User]
ON
[Report Settings Override].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Report Settings Override].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Report Settings Override table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Object ID   | Object ID | Normal | Integer | 4 | Object ID | int |
| 2 | Company Name | Company Name | Normal | Text | 30 | Company Name | nvarchar(60) |
Key to join to the Company table.Show/hide example querySELECT
[Report Settings Override].[Company Name]
,[Company].[Name]
FROM
[Report Settings Override] AS [Report Settings Override]
LEFT JOIN
[Company] AS [Company]
ON
[Report Settings Override].[Company Name] = [Company].[Name] | |||||||
| 3 | Timeout | Timeout | Normal | Integer | 4 | Timeout | int |
| 4 | MaxRows | Maximum rows | Normal | Integer | 4 | MaxRows | int |
| 5 | MaxDocuments | Maximum documents | Normal | Integer | 4 | MaxDocuments | int |
| 6 | Format Language Tag | Format Language Tag | Normal | Text | 80 | Format Language Tag | nvarchar(160) |
| 7 | Language ID | Application Language | Normal | Integer | 4 | Language ID | int |
Key to join to the Language table.Show/hide example querySELECT
[Report Settings Override].[Language ID]
,[Language].[Windows Language ID]
FROM
[Report Settings Override] AS [Report Settings Override]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Report Settings Override].[Language ID] = [Language].[Windows Language ID] | |||||||
| 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
[Report Settings Override].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[Report Settings Override] AS [Report Settings Override]
LEFT JOIN
[User] AS [User]
ON
[Report Settings Override].[$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
[Report Settings Override].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[Report Settings Override] AS [Report Settings Override]
LEFT JOIN
[User] AS [User]
ON
[Report Settings Override].[$systemModifiedBy] = [User].[User Security ID] | |||||||