Spotlight Tour Text

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

Table Number: 1997

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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Guided Experience Item Code Primary Key SearchGuided Experience Item CodeNormalCode300Guided Experience Item Codenvarchar(600)
Key to join to the Guided Experience Item table.

Show/hide example query

SELECT
       [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]
2Guided Experience Item Version Primary Key SearchVersionNormalInteger4Guided Experience Item Versionint
Key to join to the Guided Experience Item table.

Show/hide example query

SELECT
       [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]
3Spotlight Tour Step Primary Key SearchSpotlight Tour StepNormalOption4Spotlight Tour Stepint
Available options are:
  • “Step1Title”
  • “Step1Text”
  • “Step2Title”
  • “Step2Text”
4Spotlight Tour Text SearchSpotlight Tour TextNormalText250Spotlight Tour Textnvarchar(500)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [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]

Leave a Reply

Your email address will not be published. Required fields are marked *