Freigeben über


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
Values Label
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished
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
Values Label
1 Yes
0 No
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
Values Label
1 Yes
0 No
ismanaged Edm.Boolean

Tells whether the record is part of a managed solution.

Display name: State

Read only
Default options
Values Label
1 Managed
0 Unmanaged
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
Values Label
1 Yes
0 No
isuserdefined Edm.Boolean

Tells whether the view was created by a user.

Display name: User Defined

Read only
Default options
Values Label
1 Yes
0 No
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
Values Label
0 Active
1 Inactive
statuscode Edm.Int32

Shows the reason code that explains the status of the record.

Display name: Status Reason

Default options
Values Label
1 Active
2 Inactive
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

See also