Saved queries
Saved queries are business tables that define the parameters and criteria of a Microsoft Dataverse environment search. Saved queries support cross-table searches. There are two tables available for queries against the Dataverse environment.
A user query, called a saved view in the application, is owned by an individual user, can be assigned and shared with other users, and can be viewed by other users depending on the query's access privileges. This is appropriate for frequently used queries that span table types and queries that perform aggregation. More information: UserQuery table
A saved query, called a view in the application, is owned by an organization making it visible to all users in the organization. Saved queries (views) are used for both views defined for a table and for filters and templates for Dynamics 365 for Outlook. More information: SavedQuery table
A query in the form of a FetchXML statement is constructed and then assigned to the UserQuery.FetchXml
column. This query can be executed by using the ExecuteByIdUserQueryRequest message.
You can see the user query in the Advanced Find section of the model-driven app and also in the View drop-down list for a table. You can export the value of the UserQuery.FetchXml
column by using the Download Fetch XML button in the Advanced Find dialog box.
Use Web API to execute saved queries
To know about executing user query and saved query using Web API, see Retrieve and execute predefined queries
Use SDK for .NET to execute saved queries
You can use the ExecuteByIdUserQueryRequest and ExecuteByIdSavedQueryRequest messages to execute user query and saved query respectively.
คำติชม
https://aka.ms/ContentUserFeedback
เร็วๆ นี้: ตลอดปี 2024 เราจะขจัดปัญหา GitHub เพื่อเป็นกลไกคำติชมสำหรับเนื้อหา และแทนที่ด้วยระบบคำติชมใหม่ สำหรับข้อมูลเพิ่มเติม ให้ดู:ส่งและดูข้อคิดเห็นสำหรับ