Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1997
Table Type: Company
Table Name: Spotlight Tour Text
Database Table Name: CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f
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 Spotlight Tour Text can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f]
Show/hide an example select of all columns by name
SELECT
[Guided Experience Item Code]
,[Guided Experience Item Version]
,[Spotlight Tour Step]
,[Spotlight Tour Text]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Spotlight Tour Text]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[Spotlight Tour Text].[Guided Experience Item Code] = [Guided Experience Item].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[Spotlight Tour Text].[Guided Experience Item Version] = [Guided Experience Item].[Version]
LEFT JOIN
[User] AS [User]
ON
[Spotlight Tour Text].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Spotlight Tour Text].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Spotlight Tour Text table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Guided Experience Item Code | Guided Experience Item Code | Normal | Code | 300 | Guided Experience Item Code | nvarchar(600) |
Key to join to the Guided Experience Item table.Show/hide example querySELECT
[Spotlight Tour Text].[Guided Experience Item Code]
,[Guided Experience Item].[Code]
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Spotlight Tour Text]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[Spotlight Tour Text].[Guided Experience Item Code] = [Guided Experience Item].[Code] | |||||||
2 | Guided Experience Item Version | Version | Normal | Integer | 4 | Guided Experience Item Version | int |
Key to join to the Guided Experience Item table.Show/hide example querySELECT
[Spotlight Tour Text].[Guided Experience Item Version]
,[Guided Experience Item].[Version]
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Spotlight Tour Text]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[Spotlight Tour Text].[Guided Experience Item Version] = [Guided Experience Item].[Version] | |||||||
3 | Spotlight Tour Step | Spotlight Tour Step | Normal | Option | 4 | Spotlight Tour Step | int |
Available options are:
| |||||||
4 | Spotlight Tour Text | Spotlight Tour Text | Normal | Text | 250 | Spotlight Tour Text | 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
[Spotlight Tour Text].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Spotlight Tour Text]
LEFT JOIN
[User] AS [User]
ON
[Spotlight Tour Text].[$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
[Spotlight Tour Text].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Spotlight Tour Text$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Spotlight Tour Text]
LEFT JOIN
[User] AS [User]
ON
[Spotlight Tour Text].[$systemModifiedBy] = [User].[User Security ID] |