Guided Experience Item

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

Table Type: Company

Table Name: Guided Experience Item
Database Table Name: CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f

Table Number: 0

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 Guided Experience Item can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Version]
   ,[Object Type to Run]
   ,[Object ID to Run]
   ,[Link]
   ,[Title]
   ,[Short Title]
   ,[Description]
   ,[Expected Duration]
   ,[Extension ID]
   ,[Completed]
   ,[Guided Experience Type]
   ,[Assisted Setup Group]
   ,[Help Url]
   ,[Video Url]
   ,[Video Category]
   ,[Manual Setup Category]
   ,[Keywords]
   ,[Icon]
   ,[Spotlight Tour Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide columns in Guided Experience Item table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(600)
3Version Primary Key Searchint
4Object Type to Run Searchint
5Object ID to Run Searchint
6Link Searchnvarchar(500)
7Title Searchnvarchar(4096)
8Short Title Searchnvarchar(100)
9Description Searchnvarchar(2048)
10Expected Duration Searchint
11Extension ID Searchuniqueidentifier
12Completed Searchtinyint
13Guided Experience Type Searchint
14Assisted Setup Group Searchint
15Help Url Searchnvarchar(500)
16Video Url Searchnvarchar(500)
17Video Category Searchint
18Manual Setup Category Searchint
19Keywords Searchnvarchar(500)
20Icon Searchuniqueidentifier
21Spotlight Tour Type Searchint
22$systemId Searchuniqueidentifier
23$systemCreatedAt Searchdatetime
24$systemCreatedBy Searchuniqueidentifier
25$systemModifiedAt Searchdatetime
26$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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