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 כמנגנון המשוב לתוכן ונחליף אותו במערכת משוב חדשה. לקבלת מידע נוסף, ראה:שלח והצג משוב עבור