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
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για