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 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기