Table of Contents

Systems.Core.AttributeChangesHistory View

Namespace: Systems.Core

Each entry represents an entity attribute change with previous and new value. Entity: Sys_Attribute_Changes_History_View (Introduced in version 23.1.2.37)

Default Visualization

Default Display Text Format:
{RepositoryName}: {EntityItemId}
Default Search Members:
__
Category: Views
Show in UI: ShownByDefault

Aggregate

An aggregate is a cluster of domain objects that can be treated as a single unit.

Aggregate Tree

Attributes

Name Type Description
AttributeName string (64) The name of the attribute. Required Filter(eq) Inherited from Sys_Attribute_<br />Changes_Table.Attribute_Name
EntityItemId guid The id of the actual changed object, described by this change. Required Filter(multi eq) Inherited from Sys_Object_Changes_Table.Entity_Item_Id
NewValue string (max) nullable The new value. Filter(eq;like) Inherited from Sys_Attribute_<br />Changes_Table.New_Value
PreviousValue string (max) The previous value. Required Filter(eq)
RepositoryName string (64) The repository of the actual changed object, described by this change. This is different than the aggregate root, which is pointed by Root Object. Required Filter(multi eq;like) Inherited from Sys_Object_Changes_Table.Repository_Name
TimeUtc datetime Date and time (in Utc) when the changeset was processed by the server. Required Default(NowUtc) Filter(eq;ge;le) ORD Inherited from Sys_Object_Changesets_<br />Table.Time_Utc

References

Name Type Description
User Users (nullable) The user which initiated the change. null when it is unknown. Filter(multi eq) Inherited from Sys_Object_Changesets_<br />Table.User_Id

Attribute Details

AttributeName

The name of the attribute. Required Filter(eq) Inherited from Sys_Attribute_Changes_Table.Attribute_Name

Type: string (64)
Category: System
Inherited From: Sys_Attribute_Changes_Table.Attribute_Name
Supported Filters: Equals
Supports Order By: False
Maximum Length: 64
Show in UI: ShownByDefault

EntityItemId

The id of the actual changed object, described by this change. Required Filter(multi eq) Inherited from Sys_Object_Changes_Table.Entity_Item_Id

Type: guid
Category: System
Inherited From: Sys_Object_Changes_Table.Entity_Item_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

NewValue

The new value. Filter(eq;like) Inherited from Sys_Attribute_Changes_Table.New_Value

Type: string (max) nullable
Category: System
Inherited From: Sys_Attribute_Changes_Table.New_Value
Supported Filters: Equals, Like
Supports Order By: False
Maximum Length: 2147483647
Show in UI: ShownByDefault

PreviousValue

The previous value. Required Filter(eq)

Type: string (max)
Category: System
Supported Filters: Equals
Supports Order By: False
Maximum Length: 2147483647
Show in UI: ShownByDefault

RepositoryName

The repository of the actual changed object, described by this change. This is different than the aggregate root, which is pointed by Root Object. Required Filter(multi eq;like) Inherited from Sys_Object_Changes_Table.Repository_Name

Type: string (64)
Category: System
Inherited From: Sys_Object_Changes_Table.Repository_Name
Supported Filters: Equals, Like, EqualsIn
Supports Order By: False
Maximum Length: 64
Show in UI: ShownByDefault

TimeUtc

Date and time (in Utc) when the changeset was processed by the server. Required Default(NowUtc) Filter(eq;ge;le) ORD Inherited from Sys_Object_Changesets_Table.Time_Utc

Type: datetime
Category: System
Inherited From: Sys_Object_Changesets_Table.Time_Utc
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: True
Default Value: CurrentDateTimeUtc
Show in UI: ShownByDefault

Reference Details

User

The user which initiated the change. null when it is unknown. Filter(multi eq) Inherited from Sys_Object_Changesets_Table.User_Id

Type: Users (nullable)
Category: System
Inherited From: Sys_Object_Changesets_Table.User_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault

API

Domain API Query: https://demodb.my.erp.net/api/domain/odata/Systems_Core_AttributeChangesHistory?$top=10

Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Systems_Core_AttributeChangesHistory?$top=10