title | description | ms.date | ms.topic | ms.assetid | author | ms.author | search.audienceType | |
---|---|---|---|---|---|---|---|---|
Saved View (UserQuery) entity reference (Dynamics 365 Customer Engagement) | Microsoft Docs |
Includes schema information and supported messages for the Saved View (UserQuery) entity. |
08/30/2022 |
reference |
3948cc48-07c8-7f60-0608-71c37158ad7c |
KumarVivek |
matp |
|
Saved database query that is owned by a user.
Message | SDK class or method |
---|---|
Assign | xref:Microsoft.Crm.Sdk.Messages.AssignRequest |
Create | xref:Microsoft.Xrm.Sdk.Messages.CreateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Create* |
Delete | xref:Microsoft.Xrm.Sdk.Messages.DeleteRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Delete* |
ExecuteByIdUserQuery | xref:Microsoft.Crm.Sdk.Messages.ExecuteByIdUserQueryRequest |
GrantAccess | xref:Microsoft.Crm.Sdk.Messages.GrantAccessRequest |
ModifyAccess | xref:Microsoft.Crm.Sdk.Messages.ModifyAccessRequest |
Retrieve | xref:Microsoft.Xrm.Sdk.Messages.RetrieveRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Retrieve* |
RetrieveMultiple | xref:Microsoft.Xrm.Sdk.Messages.RetrieveMultipleRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.RetrieveMultiple* |
RetrievePrincipalAccess | xref:Microsoft.Crm.Sdk.Messages.RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | xref:Microsoft.Crm.Sdk.Messages.RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | xref:Microsoft.Crm.Sdk.Messages.RevokeAccessRequest |
SetState | xref:Microsoft.Crm.Sdk.Messages.SetStateRequest |
Update | xref:Microsoft.Xrm.Sdk.Messages.UpdateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Update* |
Property | Value |
---|---|
CollectionSchemaName | UserQueries |
DisplayCollectionName | Saved Views |
DisplayName | Saved View |
EntitySetName | userqueries |
IsBPFEntity | False |
LogicalCollectionName | userqueries |
LogicalName | userquery |
OwnershipType | UserOwned |
PrimaryIdAttribute | userqueryid |
PrimaryNameAttribute | name |
SchemaName | UserQuery |
These attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- AdvancedGroupBy
- ColumnSetXml
- ConditionalFormatting
- Description
- FetchXml
- LayoutJson
- LayoutXml
- Name
- OfflineSqlQuery
- OwnerId
- OwnerIdType
- ParentQueryId
- QueryType
- ReturnedTypeCode
- StateCode
- StatusCode
- UserQueryId
Property | Value |
---|---|
Description | Type the column name that will be used to group the results from the data collected across multiple records from a user view. |
DisplayName | Advanced Group By |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | advancedgroupby |
MaxLength | 20 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Shows the columns and sorting criteria for the saved view, stored in XML format. |
DisplayName | Column Set XML |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | columnsetxml |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
Property | Value |
---|---|
Description | Type information about how the items in the user view are formatted. |
DisplayName | User Group By |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | conditionalformatting |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
Property | Value |
---|---|
Description | Type additional information to describe the saved view, such as the filter criteria or intended results set. |
DisplayName | Description |
Format | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | description |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
Property | Value |
---|---|
Description | Contains the Fetch XML query that defines the entities and attributes included in the saved view. |
DisplayName | Fetch XML |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | fetchxml |
MaxLength | 1073741823 |
RequiredLevel | SystemRequired |
Type | Memo |
Property | Value |
---|---|
Description | Layout data in JSON format. |
DisplayName | Layout data in JSON format. |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | layoutjson |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Layout XML |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | layoutxml |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
Property | Value |
---|---|
Description | Type a descriptive name for the saved view. |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
MaxLength | 200 |
RequiredLevel | SystemRequired |
Type | String |
Property | Value |
---|---|
Description | String specifying the corresponding sql query for the fetch xml specified for offline use. |
DisplayName | Offline SQL Query |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | offlinesqlquery |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
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 | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Targets | systemuser,team |
Type | Owner |
Property | Value |
---|---|
Description | Type of the owner of the saved view, such as user, team, or business unit. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
Property | Value |
---|---|
Description | Choose the ID of the saved query that the record was created from. |
DisplayName | Parent Query |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | parentqueryid |
RequiredLevel | None |
Targets | |
Type | Lookup |
Property | Value |
---|---|
Description | Shows the code for the query type to indicate whether the saved view is an address book filter, advanced search, or other view. |
DisplayName | Query Type |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | querytype |
MaxValue | 1000000000 |
MinValue | 0 |
RequiredLevel | SystemRequired |
Type | Integer |
Property | Value |
---|---|
Description | Type of entity that the saved view displays. |
DisplayName | Returned Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | returnedtypecode |
RequiredLevel | SystemRequired |
Type | EntityName |
Property | Value |
---|---|
Description | Shows whether the saved view is active or inactive. |
DisplayName | Status |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 1 | Active |
1 | Inactive | 2 | Inactive |
Property | Value |
---|---|
Description | Select the item's status. |
DisplayName | Status Reason |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
Value | Label | State |
---|---|---|
1 | Active | 0 |
2 | Inactive | 1 |
3 | All | 0 |
Property | Value |
---|---|
Description | Unique identifier of the saved view. |
DisplayName | User Query |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | userqueryid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
These 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
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- VersionNumber
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | SystemRequired |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | Name of the user who created the saved view. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | YomiName of the user who created the saved view. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
Property | Value |
---|---|
Description | Shows who created the record on behalf of another user. |
DisplayName | Created By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | SystemRequired |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | Name of the user who last modified the saved view. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | YomiName of the user who last modified the saved view. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
Property | Value |
---|---|
Description | Shows who last updated the record on behalf of another user. |
DisplayName | Modified By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Name of the owner of the saved view. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Property | Value |
---|---|
Description | Shows the business unit that the record owner belongs to. |
DisplayName | Owning Business Unit |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Targets | businessunit |
Type | Lookup |
Property | Value |
---|---|
Description | Unique identifier of the team who owns this saved view. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Targets | team |
Type | Lookup |
Property | Value |
---|---|
Description | Unique identifier of the user who owns this saved view. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | Version number of the saved view. |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
Listed by SchemaName.
Same as the UserQuery_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure entity.
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | UserQuery_BulkDeleteFailures |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Same as the UserQuery_SyncErrors many-to-one relationship for the syncerror entity.
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | UserQuery_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Same as the UserQuery_AsyncOperations many-to-one relationship for the asyncoperation entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | UserQuery_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related entity. Listed by SchemaName.
- lk_userquery_modifiedonbehalfby
- business_unit_userquery
- user_userquery
- team_userquery
- lk_userquery_modifiedby
- lk_userquery_createdby
- lk_userquery_createdonbehalfby
See the lk_userquery_modifiedonbehalfby one-to-many relationship for the systemuser entity.
See the business_unit_userquery one-to-many relationship for the businessunit entity.
See the user_userquery one-to-many relationship for the systemuser entity.
See the team_userquery one-to-many relationship for the team entity.
See the lk_userquery_modifiedby one-to-many relationship for the systemuser entity.
See the lk_userquery_createdby one-to-many relationship for the systemuser entity.
See the lk_userquery_createdonbehalfby one-to-many relationship for the systemuser entity.