Assisted Setup

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

Table Type: Company

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

Table Number: 1803

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Page ID]
   ,[Name]
   ,[Order]
   ,[Status]
   ,[Visible]
   ,[Parent]
   ,[Video Url]
   ,[Icon]
   ,[Item Type]
   ,[Featured]
   ,[Help Url]
   ,[Assisted Setup Page ID]
   ,[Tour Id]
   ,[Video Status]
   ,[Help Status]
   ,[Tour Status]
   ,[App ID]
   ,[Group Name]
   ,[Completed]
   ,[Video Category]
   ,[Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Assisted Setup$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide columns in Assisted Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Page ID Primary Key Searchint
3Name Searchnvarchar(4096)
4Order Searchint
5Status Searchint
6Visible Searchtinyint
7Parent Searchint
8Video Url Searchnvarchar(500)
9Icon Searchuniqueidentifier
10Item Type Searchint
11Featured Searchtinyint
12Help Url Searchnvarchar(500)
13Assisted Setup Page ID Searchint
14Tour Id Searchint
15Video Status Searchtinyint
16Help Status Searchtinyint
17Tour Status Searchtinyint
18App ID Searchuniqueidentifier
19Group Name Searchint
20Completed Searchtinyint
21Video Category Searchint
22Description Searchnvarchar(2048)
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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