Aggregated Assisted Setup

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1808

Table Type: Company

Table Name: Aggregated Assisted Setup
Database Table Name: CRONUS UK Ltd_$Aggregated Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f

Table Number: 1808

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 Aggregated Assisted Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Aggregated Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT
   [Page ID]
   ,[Name]
   ,[Order]
   ,[Status]
   ,[Visible]
   ,[Icon]
   ,[Item Type]
   ,[Assisted Setup Page ID]
   ,[External Assisted Setup]
   ,[Record ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Aggregated Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Aggregated Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Aggregated Assisted Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Aggregated Assisted Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Aggregated Assisted Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Aggregated Assisted Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Page ID Primary Key SearchPage IDNormalInteger4Page IDint
2Name SearchNameNormalText250Namenvarchar(500)
3Order SearchOrderNormalInteger4Orderint
4Status SearchStatusNormalOption4Statusint
Available options are:
  • “Not Completed”
  • “Completed”
  • “Not Started”
  • “Seen”
  • “Watched”
  • “Read”
  • ” “
5Visible SearchVisibleNormalBoolean4Visibletinyint
8Icon SearchIconNormalMedia16Iconuniqueidentifier
9Item Type SearchItem TypeNormalOption4Item Typeint
Available options are:
  • ” “
  • “Group”
  • “Setup and Help”
12Assisted Setup Page ID SearchAssisted Setup Page IDNormalInteger4Assisted Setup Page IDint
17External Assisted Setup SearchExternal Assisted SetupNormalBoolean4External Assisted Setuptinyint
18Record ID SearchRecord IDNormalRecordID448Record IDvarbinary(448)
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
       [Aggregated Assisted Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Aggregated Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Aggregated Assisted Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Aggregated Assisted Setup].[$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
       [Aggregated Assisted Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Aggregated Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Aggregated Assisted Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Aggregated Assisted Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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