savedquery EntityType
Saved query against the database.
- Entity Set Path
- [organization URI]/api/data/v9.0/savedqueries
- Base Type
- crmbaseentity
- Display Name
- View
- Primary Key
- savedqueryid
- Primary Key Attribute
- 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 system view. Display Name: Advanced Group By |
||||||||||
| canbedeleted | BooleanManagedProperty |
Tells whether the view can be deleted. Display Name: Can Be Deleted |
||||||||||
| columnsetxml | Edm.String |
Contains the columns and sorting criteria for the view, stored in XML format. Display Name: Column Set XML |
||||||||||
| componentstate | Edm.Int32 |
For internal use only. Display Name: Component State Read Only
Default Options
|
||||||||||
| conditionalformatting | Edm.String |
Type information about how the items in the system view are formatted. Display Name: Conditional formatting |
||||||||||
| 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 view, such as the filter criteria or intended results set. Display Name: Description |
||||||||||
| fetchxml | Edm.String |
String specifying the query in Fetch XML language. Display Name: Fetch XML |
||||||||||
| introducedversion | Edm.String |
Version in which the form is introduced. Display Name: Introduced Version |
||||||||||
| iscustom | Edm.Boolean |
Tells whether a user created the view. Display Name: Is Custom Read Only
Default Options
|
||||||||||
| iscustomizable | BooleanManagedProperty |
Tells whether the component can be customized. Display Name: Customizable |
||||||||||
| isdefault | Edm.Boolean |
Tells whether the view is the default view for the specified record type (entity). Display Name: Default
Default Options
|
||||||||||
| ismanaged | Edm.Boolean |
Tells whether the record is part of a managed solution. Display Name: State Read Only
Default Options
|
||||||||||
| isquickfindquery | Edm.Boolean |
Choose whether the view is compatible with Quick Find. When users search for specific items, you define the fields that are searched in. Display Name: Quick Find Compatible
Default Options
|
||||||||||
| isuserdefined | Edm.Boolean |
Tells whether the view was created by a user. Display Name: User Defined Read Only
Default Options
|
||||||||||
| 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: Modified On Read Only
|
||||||||||
| name | Edm.String |
Type a name for the view to describe what results the view will contain. This name is visible to users in the View list. 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 |
||||||||||
| organizationtaborder | Edm.Int32 |
For the organization, type the tab order to determine how users navigate through the screen using only the Tab key. Display Name: Default Organization tab order Read Only
|
||||||||||
| overwritetime | Edm.DateTimeOffset |
For internal use only. Display Name: Record Overwrite Time Read Only
|
||||||||||
| queryapi | Edm.String |
For internal use only. Display Name: Query API Read Only
|
||||||||||
| queryappusage | Edm.Int32 |
For internal use only. Display Name: Query Application Usage |
||||||||||
| querytype | Edm.Int32 |
Shows the type of the query. Display Name: Query Type |
||||||||||
| returnedtypecode | Edm.String |
Type of entity displayed in the view. Display Name: Entity Name |
||||||||||
| savedqueryid | Edm.Guid |
Unique identifier of the view. Display Name: View |
||||||||||
| savedqueryidunique | Edm.Guid |
For internal use only. Read Only
|
||||||||||
| solutionid | Edm.Guid |
Unique identifier of the associated solution. Display Name: Solution Read Only
|
||||||||||
| statecode | Edm.Int32 |
Shows the status of the view. Display Name: Status
Default Options
|
||||||||||
| statuscode | Edm.Int32 |
Shows the reason code that explains the status of the record. Display Name: Status Reason
Default Options
|
||||||||||
| versionnumber | Edm.Int64 |
Version number of the 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 Retrieve data about lookup properties.
| 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. |
| _organizationid_value | organizationid |
Choose the ID of the organization that the record is associated with. |
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_savedquerybase_createdby |
| createdonbehalfby | systemuser | lk_savedquery_createdonbehalfby |
| modifiedby | systemuser | lk_savedquerybase_modifiedby |
| modifiedonbehalfby | systemuser | lk_savedquery_modifiedonbehalfby |
| organizationid | organization | organization_saved_queries |
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 |
|---|---|---|
| lk_mobileofflineprofileitem_savedquery | mobileofflineprofileitem | profileitemrule |
| SavedQuery_AsyncOperations | asyncoperation | regardingobjectid_savedquery |
| SavedQuery_BulkDeleteFailures | bulkdeletefailure | regardingobjectid_savedquery |
| SavedQuery_SyncErrors | syncerror | regardingobjectid_savedquery_syncerror |
Operations
The following operations can be used with the savedquery entity type.
| Name | Binding |
|---|---|
| InstantiateFilters | Not Bound |
| RetrieveUnpublished | Entity |
| RetrieveUnpublishedMultiple | Collection |
| Validate | Not Bound |
| ValidateSavedQuery | Collection |
| ValidateUnpublished | Not Bound |
Solutions
The following solutions include the savedquery entity type.
| Name | Description |
|---|---|
| System Solution | Internal CRM System Solution |
| Second Patch for Application Common | For internal use only. |
| Application Common | For internal use only. |
| Application Common Patch | For internal use only. |