savedquery EntityType
Saved query against the database.
- Entity set path:
- [organization URI]/api/data/v9.2/savedqueries
- Base type:
- crmbaseentity
- Table type:
- Standard
- 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 |
||||||||||
roledisplayconditionsxml | Edm.String |
Contains the role display conditions for the SavedQuery. Display name: Role display conditions for the SavedQuery |
||||||||||
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 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. |
_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 | Bound to Entity |
RetrieveUnpublishedMultiple | Bound to Collection |
Validate | Not Bound |
ValidateSavedQuery | Bound to Collection |
ValidateUnpublished | Not Bound |