userquery EntityType
Saved database query that is owned by a user.
- Entity set path:
- [organization URI]/api/data/v9.2/userqueries
- Base type:
- crmbaseentity
- Table type:
- Standard
- Display name:
- Saved View
- Primary key:
- userqueryid
- Primary name column:
- name
- Operations supported:
- POST GET PATCH DELETE
Properties
Properties represent fields of data stored in the entity. Some properties are read-only.
| Name | Type | Details | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| advancedgroupby | Edm.String |
Type the column name that will be used to group the results from the data collected across multiple records from a user view. Display name: Advanced Group By |
||||||||
| columnsetxml | Edm.String |
Shows the columns and sorting criteria for the saved view, stored in XML format. Display name: Column Set XML |
||||||||
| conditionalformatting | Edm.String |
Type information about how the items in the user view are formatted. Display name: User Group By |
||||||||
| createdon | Edm.DateTimeOffset |
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. Display name: Created On Read only
|
||||||||
| description | Edm.String |
Type additional information to describe the saved view, such as the filter criteria or intended results set. Display name: Description |
||||||||
| fetchxml | Edm.String |
Contains the Fetch XML query that defines the entities and attributes included in the saved view. Display name: Fetch XML |
||||||||
| layoutjson | Edm.String |
Layout data in JSON format. Display name: Layout data in JSON format. |
||||||||
| layoutxml | Edm.String |
For internal use only. Display name: Layout XML |
||||||||
| modifiedon | Edm.DateTimeOffset |
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. Display name: Last Modified Read only
|
||||||||
| name | Edm.String |
Type a descriptive name for the saved view. Display name: Name |
||||||||
| offlinesqlquery | Edm.String |
String specifying the corresponding sql query for the fetch xml specified for offline use. Display name: Offline SQL Query |
||||||||
| querytype | Edm.Int32 |
Shows the code for the query type to indicate whether the saved view is an address book filter, advanced search, or other view. Display name: Query Type |
||||||||
| returnedtypecode | Edm.String |
Type of entity that the saved view displays. Display name: Returned Type |
||||||||
| statecode | Edm.Int32 |
Shows whether the saved view is active or inactive. Display name: Status
Default options
|
||||||||
| statuscode | Edm.Int32 |
Select the item's status. Display name: Status Reason
Default options
|
||||||||
| userqueryid | Edm.Guid |
Unique identifier of the saved view. Display name: User Query |
||||||||
| versionnumber | Edm.Int64 |
Version number of the saved view. Display name: Version Number Read only
|
Lookup properties
Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Lookup property data.
| Name | Single-valued navigation property | Description |
|---|---|---|
| _createdby_value | createdby |
Shows who created the record. |
| _createdonbehalfby_value | createdonbehalfby |
Shows who created the record on behalf of another user. |
| _modifiedby_value | modifiedby |
Shows who last updated the record. |
| _modifiedonbehalfby_value | modifiedonbehalfby |
Shows who last updated the record on behalf of another user. |
| _ownerid_value | ownerid |
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. |
| _owningbusinessunit_value | owningbusinessunit |
Shows the business unit that the record owner belongs to. |
| _owningteam_value | owningteam |
Unique identifier of the team who owns this saved view. |
| _owninguser_value | owninguser |
Unique identifier of the user who owns this saved view. |
Single-valued navigation properties
Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.
| Name | Type | Partner |
|---|---|---|
| createdby | systemuser | lk_userquery_createdby |
| createdonbehalfby | systemuser | lk_userquery_createdonbehalfby |
| modifiedby | systemuser | lk_userquery_modifiedby |
| modifiedonbehalfby | systemuser | lk_userquery_modifiedonbehalfby |
| ownerid | principal | owner_userquerys |
| owningbusinessunit | businessunit | business_unit_userquery |
| owningteam | team | team_userquery |
| owninguser | systemuser | user_userquery |
Collection-valued navigation properties
Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.
| Name | Type | Partner |
|---|---|---|
| UserQuery_AsyncOperations | asyncoperation | regardingobjectid_userquery |
| UserQuery_BulkDeleteFailures | bulkdeletefailure | regardingobjectid_userquery |
| UserQuery_SyncErrors | syncerror | regardingobjectid_userquery_syncerror |
Operations
The following operations can be used with the userquery entity type.
| Name | Binding |
|---|---|
| GrantAccess | Not Bound |
| ModifyAccess | Not Bound |
| RetrievePrincipalAccess | Not Bound |
| RetrieveSharedPrincipalsAndAccess | Not Bound |
| RevokeAccess | Not Bound |