userquery EntityType

 

Applies To: Dynamics 365 (online), Dynamics 365 (on-premises), Dynamics CRM 2016, Dynamics CRM Online

Description: Saved database query that is owned by a user.

Entity Set path:[organization URI]/api/data/v8.2/userqueries

Base Type: crmbaseentity EntityType

Display Name: Saved View

Primary Key: userqueryid

Primary Name Attribute: name

Properties

Lookup Properties

Single-valued navigation properties

Collection-valued navigation properties

Properties

Properties represent fields of data stored in the entity. Some properties are read-only.

Name

Type

Details

advancedgroupby

Edm.String

Description: 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

Description: Shows the columns and sorting criteria for the saved view, stored in XML format.

Display Name: Column Set XML

conditionalformatting

Edm.String

Description: Type information about how the items in the user view are formatted.

Display Name: User Group By

createdon

Edm.DateTimeOffset

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.

Display Name: Created On

Read-only property

description

Edm.String

Description: Type additional information to describe the saved view, such as the filter criteria or intended results set.

Display Name: Description

fetchxml

Edm.String

Description: Contains the Fetch XML query that defines the entities and attributes included in the saved view.

Display Name: Fetch XML

layoutxml

Edm.String

Description: For internal use only.

Display Name: Layout XML

modifiedon

Edm.DateTimeOffset

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.

Display Name: Last Modified

Read-only property

name

Edm.String

Description: Type a descriptive name for the saved view.

Display Name: Name

querytype

Edm.Int32

Description: 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

Description: Type of entity that the saved view displays.

Display Name: Returned Type

statecode

Edm.Int32

Description: Shows whether the saved view is active or inactive.

Default Options:

0 : Active
1 : Inactive

Display Name: Status

statuscode

Edm.Int32

Description: Select the item's status.

Default Options:

1 : Active
3 : All
2 : Inactive

Display Name: Status Reason

userqueryid

Edm.Guid

Description: Unique identifier of the saved view.

Display Name: User Query

versionnumber

Edm.Int64

Description: Version number of the saved view.

Display Name: Version Number

Read-only property

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.

_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.

_parentqueryid_value

Choose the ID of the saved query that the record was created from.

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 EntityType

lk_userquery_createdby

createdonbehalfby

systemuser EntityType

lk_userquery_createdonbehalfby

modifiedby

systemuser EntityType

lk_userquery_modifiedby

modifiedonbehalfby

systemuser EntityType

lk_userquery_modifiedonbehalfby

ownerid

principal EntityType

owner_userquerys

owningbusinessunit

businessunit EntityType

business_unit_userquery

owningteam

team EntityType

team_userquery

owninguser

systemuser EntityType

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 EntityType

regardingobjectid_userquery

UserQuery_BulkDeleteFailures

bulkdeletefailure EntityType

regardingobjectid_userquery

UserQuery_SyncErrors

syncerror EntityType

regardingobjectid_userquery_syncerror

See Also

Use the Microsoft Dynamics 365 Web API
Web API Action Reference
Web API Function Reference
Web API Query Function Reference
Web API EnumType Reference
Web API ComplexType Reference
Web API Metadata EntityType Reference

Microsoft Dynamics 365

© 2016 Microsoft. All rights reserved. Copyright