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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | User SID  | uniqueidentifier |
| 3 | Object Type | int |
| 4 | Object ID | int |
| 5 | Personalization ID | nvarchar(80) |
| 6 | ValueName | nvarchar(80) |
| 7 | Date | datetime |
| 8 | Time | datetime |
| 9 | Value | image |
| 10 | $systemId | uniqueidentifier |
| 11 | $systemCreatedAt | datetime |
| 12 | $systemCreatedBy | uniqueidentifier |
| 13 | $systemModifiedAt | datetime |
| 14 | $systemModifiedBy | uniqueidentifier |