Page Data Personalization

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

Table Type: System

Table Name: Page Data Personalization
Database Table Name: Page Data Personalization

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 Page Data Personalization can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Page Data Personalization]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[User SID]
   ,[Object Type]
   ,[Object ID]
   ,[Personalization ID]
   ,[ValueName]
   ,[Date]
   ,[Time]
   ,[Value]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Page Data Personalization]

Show/hide columns in Page Data Personalization table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User SID Primary Key Searchuniqueidentifier
3Object Type Primary Key Searchint
4Object ID Primary Key Searchint
5Personalization ID Primary Key Searchnvarchar(80)
6ValueName Primary Key Searchnvarchar(80)
7Date Searchdatetime
8Time Searchdatetime
9Value Searchimage
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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