แก้ไข

แชร์ผ่าน

System Chart (SavedQueryVisualization) table/entity reference

  • บทความ

System chart attached to an entity.

Messages

The following table lists the messages for the System Chart (SavedQueryVisualization) table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?		 Web API Operation SDK for .NET
Create
Event: False		 POST /savedqueryvisualizations
See Create		 Create records
Delete
Event: False		 DELETE /savedqueryvisualizations(savedqueryvisualizationid)
See Delete		 Delete records
Retrieve
Event: True		 GET /savedqueryvisualizations(savedqueryvisualizationid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: True		 GET /savedqueryvisualizations
See Query data		 Query data
RetrieveUnpublished
Event: False		 RetrieveUnpublished RetrieveUnpublishedRequest
RetrieveUnpublishedMultiple
Event: False		 RetrieveUnpublishedMultiple RetrieveUnpublishedMultipleRequest
Update
Event: False		 PATCH /savedqueryvisualizations(savedqueryvisualizationid)
See Update		 Update records
Upsert
Event: False		 PATCH /savedqueryvisualizations(savedqueryvisualizationid)
See Upsert a table row		 UpsertRequest

Properties

The following table lists selected properties for the System Chart (SavedQueryVisualization) table.

Property Value
DisplayName System Chart
DisplayCollectionName System Charts
SchemaName SavedQueryVisualization
CollectionSchemaName SavedQueryVisualizations
EntitySetName savedqueryvisualizations
LogicalName savedqueryvisualization
LogicalCollectionName savedqueryvisualizations
PrimaryIdAttribute savedqueryvisualizationid
PrimaryNameAttribute name
TableType Standard
OwnershipType OrganizationOwned

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

CanBeDeleted

Property Value
Description Tells whether the saved query visualization can be deleted.
DisplayName Can Be Deleted
IsValidForForm False
IsValidForRead True
LogicalName canbedeleted
RequiredLevel SystemRequired
Type ManagedProperty

ChartType

Property Value
Description Indicates the library used to render the visualization.
DisplayName Chart Type
IsValidForForm False
IsValidForRead True
LogicalName charttype
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 0
GlobalChoiceName savedqueryvisualization_charttype

ChartType Choices/Options

Value Label
0 ASP.NET Charts
1 Power BI

DataDescription

Property Value
Description XML string used to define the underlying data for the system chart.
DisplayName Data XML
IsValidForForm False
IsValidForRead True
LogicalName datadescription
RequiredLevel None
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 1073741823

Description

Property Value
Description Description of the system chart.
DisplayName Description
IsValidForForm False
IsValidForRead True
LogicalName description
RequiredLevel None
Type Memo
Format Text
FormatName Text
ImeMode Auto
IsLocalizable True
MaxLength 2000

IntroducedVersion

Property Value
Description Version in which the form is introduced.
DisplayName Introduced Version
IsValidForForm False
IsValidForRead True
LogicalName introducedversion
RequiredLevel None
Type String
Format VersionNumber
FormatName VersionNumber
ImeMode Auto
IsLocalizable False
MaxLength 48

IsCustomizable

Property Value
Description Information that specifies whether this component can be customized.
DisplayName Customizable
IsValidForForm False
IsValidForRead True
LogicalName iscustomizable
RequiredLevel SystemRequired
Type ManagedProperty

IsDefault

Property Value
Description Indicates whether the system chart is the default chart for the entity.
DisplayName Default Chart
IsValidForForm False
IsValidForRead True
LogicalName isdefault
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName savedqueryvisualization_isdefault
DefaultValue False
True Label Yes
False Label No

Name

Property Value
Description Name of the system chart.
DisplayName Name
IsValidForForm False
IsValidForRead True
LogicalName name
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable True
MaxLength 100

PresentationDescription

Property Value
Description XML string used to define the presentation properties of the system chart.
DisplayName Presentation XML
IsValidForForm False
IsValidForRead True
LogicalName presentationdescription
RequiredLevel None
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 1073741823

PrimaryEntityTypeCode

Property Value
Description Type of entity with which the system chart is attached.
DisplayName Primary Type Code
IsValidForForm False
IsValidForRead True
LogicalName primaryentitytypecode
RequiredLevel SystemRequired
Type EntityName

SavedQueryVisualizationId

Property Value
Description Unique identifier of the system chart.
DisplayName System Chart
IsValidForForm False
IsValidForRead True
LogicalName savedqueryvisualizationid
RequiredLevel SystemRequired
Type Uniqueidentifier

Type

Property Value
Description Specifies where the chart will be used, 0 for data centric as well as interaction centric and 1 for just interaction centric
DisplayName Form Type
IsValidForForm False
IsValidForRead True
LogicalName type
RequiredLevel None
Type Picklist
DefaultFormValue 0
GlobalChoiceName chart_usage

Type Choices/Options

Value Label
0 for data centric as well as interaction centric
1 just for interaction centric

WebResourceId

Property Value
Description Unique identifier of the Web resource that will be displayed in the system chart.
DisplayName Web Resource
IsValidForForm False
IsValidForRead True
LogicalName webresourceid
RequiredLevel None
Type Lookup
Targets webresource

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

ComponentState

Property Value
Description For internal use only.
DisplayName Component State
IsValidForForm False
IsValidForRead True
LogicalName componentstate
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName componentstate

ComponentState Choices/Options

Value Label
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished

CreatedBy

Property Value
Description Unique identifier of the user who created the system chart.
DisplayName Created By
IsValidForForm False
IsValidForRead True
LogicalName createdby
RequiredLevel None
Type Lookup
Targets systemuser

CreatedOn

Property Value
Description Date and time when the system chart was created.
DisplayName Created On
IsValidForForm False
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

CreatedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who created the system chart.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

IsManaged

Property Value
Description Indicates whether the solution component is part of a managed solution.
DisplayName Is Managed
IsValidForForm False
IsValidForRead True
LogicalName ismanaged
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName ismanaged
DefaultValue False
True Label Managed
False Label Unmanaged

ModifiedBy

Property Value
Description Unique identifier of the user who last modified the system chart.
DisplayName Modified By
IsValidForForm False
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Type Lookup
Targets systemuser

ModifiedOn

Property Value
Description Date and time when the system chart was last modified.
DisplayName Modified On
IsValidForForm False
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who last modified the system chart.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

OrganizationId

Property Value
Description Unique identifier of the organization associated with the system chart.
DisplayName Organization
IsValidForForm False
IsValidForRead True
LogicalName organizationid
RequiredLevel SystemRequired
Type Lookup
Targets organization

OverwriteTime

Property Value
Description For internal use only.
DisplayName Record Overwrite Time
IsValidForForm False
IsValidForRead True
LogicalName overwritetime
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Inactive
SourceTypeMask 0

SavedQueryVisualizationIdUnique

Property Value
Description For internal use only.
DisplayName System Chart
IsValidForForm False
IsValidForRead True
LogicalName savedqueryvisualizationidunique
RequiredLevel SystemRequired
Type Uniqueidentifier

SolutionId

Property Value
Description Unique identifier of the associated solution.
DisplayName Solution
IsValidForForm False
IsValidForRead True
LogicalName solutionid
RequiredLevel SystemRequired
Type Uniqueidentifier

SupportingSolutionId

Property Value
Description For internal use only.
DisplayName Solution
IsValidForForm False
IsValidForRead False
LogicalName supportingsolutionid
RequiredLevel None
Type Uniqueidentifier

VersionNumber

Property Value
Description Version number of the system chart.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
RequiredLevel None
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

lk_savedqueryvisualizationbase_createdby

One-To-Many Relationship: systemuser lk_savedqueryvisualizationbase_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_savedqueryvisualizationbase_createdonbehalfby

One-To-Many Relationship: systemuser lk_savedqueryvisualizationbase_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_savedqueryvisualizationbase_modifiedby

One-To-Many Relationship: systemuser lk_savedqueryvisualizationbase_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_savedqueryvisualizationbase_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_savedqueryvisualizationbase_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

organization_saved_query_visualizations

One-To-Many Relationship: organization organization_saved_query_visualizations

Property Value
ReferencedEntity organization
ReferencedAttribute organizationid
ReferencingAttribute organizationid
ReferencingEntityNavigationPropertyName organizationid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

webresource_savedqueryvisualizations

One-To-Many Relationship: webresource webresource_savedqueryvisualizations

Property Value
ReferencedEntity webresource
ReferencedAttribute webresourceid
ReferencingAttribute webresourceid
ReferencingEntityNavigationPropertyName webresourceid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

SavedQueryVisualization_SyncErrors

Many-To-One Relationship: syncerror SavedQueryVisualization_SyncErrors

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName SavedQueryVisualization_SyncErrors
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
savedqueryvisualization