Table Cmm_Notifications

Entity

A single notification of a user. Entity: Cmm_Notifications (Introduced in version 20.1)

Summary

Name	Type	Description
Anchor	`nvarchar(128)`	A custom reference (most commonly a relative URL) pointing to an additional resource related to the DataObject.
Creation_Time_Utc	`datetime` Readonly	The exact server time (in UTC), when the notification was created.
Data_Object_Id	`uniqueidentifier`	The data object about which the notification is created. Null means that the notification is not about any specific data object.
Is_Read	`bit`	Specifies whether the user has read the notification. If the system changes the notification after first reading, the flag is reset to unread again.
Notification_Class	`nvarchar(64)`	The class of the notification from a predefined list of system classes.
Notification_Id	`uniqueidentifier` `PK`
Row_Version	`timestamp`
Subject	`nvarchar(256)`	The short subject of the notification (in the Default Culture of the user).
User_Id	`uniqueidentifier`	The user, who is notified.

Columns

Anchor

A custom reference (most commonly a relative URL) pointing to an additional resource related to the DataObject.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	128
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(128) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Creation_Time_Utc

The exact server time (in UTC), when the notification was created.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	CurrentDateTimeUtc
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	no
Type	datetime
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Creation_Time_Utc - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	no	no

Data_Object_Id

The data object about which the notification is created. Null means that the notification is not about any specific data object.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Sys_Objects
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Data_Object_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Is_Read

Specifies whether the user has read the notification. If the system changes the notification after first reading, the flag is reset to unread again.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	False
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bit
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Is_Read - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Notification_Class

The class of the notification from a predefined list of system classes.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	64
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	nvarchar(64)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Notification_Class - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Notification_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	NewGuid
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Notification_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Row_Version

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Subject

The short subject of the notification (in the Default Culture of the user).

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	256
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(256) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Subject - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no
Like	None	no	no

User_Id

The user, who is notified.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Sec_Users
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

User_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Table of Contents