User Chart (UserQueryVisualization) table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Chart attached to an entity.
Messages
| Message | Web API Operation | SDK class or method |
|---|---|---|
| Assign | PATCH /userqueryvisualizations(userqueryvisualizationid) Update ownerid property. |
AssignRequest |
| Create | POST /userqueryvisualizations See Create |
CreateRequest or Create |
| Delete | DELETE /userqueryvisualizations(userqueryvisualizationid) See Delete |
DeleteRequest or Delete |
| GrantAccess | GrantAccess | GrantAccessRequest |
| ModifyAccess | ModifyAccess | ModifyAccessRequest |
| Retrieve | GET /userqueryvisualizations(userqueryvisualizationid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET /userqueryvisualizations See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess | RevokeAccessRequest |
| Update | PATCH /userqueryvisualizations(userqueryvisualizationid) See Update |
UpdateRequest or Update |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | UserQueryVisualizations |
| DisplayCollectionName | User Charts |
| DisplayName | User Chart |
| EntitySetName | userqueryvisualizations |
| IsBPFEntity | False |
| LogicalCollectionName | userqueryvisualizations |
| LogicalName | userqueryvisualization |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | userqueryvisualizationid |
| PrimaryNameAttribute | name |
| SchemaName | UserQueryVisualization |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ChartType
- DataDescription
- Description
- IsDefault
- Name
- OwnerId
- OwnerIdType
- PresentationDescription
- PrimaryEntityTypeCode
- UserQueryVisualizationId
- WebResourceId
ChartType
| Property | Value |
|---|---|
| Description | Indicates the library used to render the visualization. |
| DisplayName | Chart Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | charttype |
| RequiredLevel | ApplicationRequired |
| Type | Picklist |
ChartType Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | ASP.NET Charts | |
| 1 | Power BI |
DataDescription
| Property | Value |
|---|---|
| Description | Shows the fields that are used to display data in a chart, stored in XML format. |
| DisplayName | Data XML |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | datadescription |
| MaxLength | 1073741823 |
| RequiredLevel | None |
| Type | Memo |
Description
| Property | Value |
|---|---|
| Description | Type additional information to describe the chart, such as the filter criteria or intended audience. |
| DisplayName | Description |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
IsDefault
| Property | Value |
|---|---|
| Description | Select whether the chart is the default chart for the view that it is associated with. |
| DisplayName | Default Chart |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | isdefault |
| RequiredLevel | SystemRequired |
| Type | Boolean |
IsDefault Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
Name
| Property | Value |
|---|---|
| Description | Type a descriptive name for the chart. |
| DisplayName | Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | name |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerId
| Property | Value |
|---|---|
| Description | Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. |
| DisplayName | Owner |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Targets | systemuser,team |
| Type | Owner |
OwnerIdType
| Property | Value |
|---|---|
| Description | Type of the owner of the user chart, such as user, team, or business unit. |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
PresentationDescription
| Property | Value |
|---|---|
| Description | Contains the chart's formatting details and presentation properties, stored in XML format. |
| DisplayName | Presentation XML |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | presentationdescription |
| MaxLength | 1073741823 |
| RequiredLevel | None |
| Type | Memo |
PrimaryEntityTypeCode
| Property | Value |
|---|---|
| Description | Type of entity which the user chart is attached. |
| DisplayName | Primary Type Code |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | primaryentitytypecode |
| RequiredLevel | SystemRequired |
| Type | EntityName |
UserQueryVisualizationId
| Property | Value |
|---|---|
| Description | Unique identifier of the user chart. |
| DisplayName | User Chart |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | userqueryvisualizationid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
WebResourceId
| Property | Value |
|---|---|
| Description | Shows the web resource that will be displayed in the chart to the user. |
| DisplayName | Web Resource |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | webresourceid |
| RequiredLevel | None |
| Targets | webresource |
| Type | Lookup |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerIdName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- VersionNumber
CreatedBy
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | SystemRequired |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Property | Value |
|---|---|
| Description | Name of the user who created the user chart. |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Property | Value |
|---|---|
| Description | YomiName of the user who created the user chart. |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | SystemRequired |
| Type | DateTime |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who created the record on behalf of another user. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | SystemRequired |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Property | Value |
|---|---|
| Description | Name of the user who last modified the user chart. |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Property | Value |
|---|---|
| Description | YomiName of the user who last modified the user chart. |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
| DisplayName | Last Modified |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | SystemRequired |
| Type | DateTime |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who created the record on behalf of another user. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OwnerIdName
| Property | Value |
|---|---|
| Description | Name of the owner of the user chart. |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Shows the business unit that the record owner belongs to. |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | ApplicationRequired |
| Targets | businessunit |
| Type | Lookup |
OwningBusinessUnitName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunitname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier of the team who owns the user chart. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | ApplicationRequired |
| Targets | team |
| Type | Lookup |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier of the team who owns the user chart. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | ApplicationRequired |
| Targets | systemuser |
| Type | Lookup |
VersionNumber
| Property | Value |
|---|---|
| Description | Version number of the user chart. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
UserQueryVisualization_SyncErrors
Same as the UserQueryVisualization_SyncErrors many-to-one relationship for the syncerror table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | UserQueryVisualization_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- lk_userqueryvisualizationbase_modifiedonbehalfby
- user_userqueryvisualizations
- webresource_userqueryvisualizations
- lk_userqueryvisualizationbase_createdonbehalfby
- team_userqueryvisualizations
- business_unit_userqueryvisualizations
- lk_userqueryvisualization_createdby
- lk_userqueryvisualization_modifiedby
lk_userqueryvisualizationbase_modifiedonbehalfby
See the lk_userqueryvisualizationbase_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
user_userqueryvisualizations
See the user_userqueryvisualizations one-to-many relationship for the systemuser table/entity.
webresource_userqueryvisualizations
See the webresource_userqueryvisualizations one-to-many relationship for the webresource table/entity.
lk_userqueryvisualizationbase_createdonbehalfby
See the lk_userqueryvisualizationbase_createdonbehalfby one-to-many relationship for the systemuser table/entity.
team_userqueryvisualizations
See the team_userqueryvisualizations one-to-many relationship for the team table/entity.
business_unit_userqueryvisualizations
See the business_unit_userqueryvisualizations one-to-many relationship for the businessunit table/entity.
lk_userqueryvisualization_createdby
See the lk_userqueryvisualization_createdby one-to-many relationship for the systemuser table/entity.
lk_userqueryvisualization_modifiedby
See the lk_userqueryvisualization_modifiedby one-to-many relationship for the systemuser table/entity.
See also
Dataverse table/entity reference
Web API Reference
userqueryvisualization EntityType
Geri Bildirim
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz. https://aka.ms/ContentUserFeedback.
Gönderin ve geri bildirimi görüntüleyin