userquery EntityType

Dynamics CRM 2016
 

Updated: November 29, 2016

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

Microsoft Dynamics 365

© 2016 Microsoft. All rights reserved. Copyright

Community Additions

ADD
Show: