Using valueof Attribute for FetchXML Filters | Cross-Table Comparisons
In this article, you'll discover how to utilize the valueof attribute within FetchXML to create filters that compare column values within the same row. This technique can be used in a number of scenarios, such as finding contact records where the firstname column matches the lastname column (Scenario 1) or performing cross table comparisons to fetch rows where the contact fullname column matches the account name column (Scenario 2).
If you're looking for more information on utilizing FetchXML and other Microsoft Dynamics 365 tools, be sure to check out the author's other articles.
Link to the article: https://rajeevpentyala.com/2024/04/28/fetchxml-filter-on-column-values-in-the-same-row/
Published on:
Learn moreRelated posts
Filter Related Records with addPreSearch() | Model Driven App
In this experiment, the author attempts to combine the addPreSearch() method in the Client API with the recently documented FetchXml functiona...
Custom Lookup Filtering In Basic Forms – Power Pages
In this blog we will see how to use custom lookup filtering in basic forms. Basic forms in power pages with lookup fields often face issue wit...
Filtering Dynamics 365 Finance and Operations Dataverse Virtual Entities in Customer Portal
Filtering Dynamics 365 Finance and Operations Dataverse Virtual Entities in Customer Portal Fabien Leal Fri, 04/28/2023 - 11:35 Body ...
How to Filter MS CRM Lookup with Custom Conditions Using JavaScript?
In the world of customer relationship management, Microsoft Dynamics CRM is a popular platform that offers businesses the ability to effective...
CONVERT QUERYEXPRESSION TO FETCHXML AND VICE-VERSA IN DYNAMICS 365
In this post, you will learn about converting Query Expression to FetchXML and vice versa in Dynamics 365. Dynamics 365 is a powerful tool for...
Column comparison using FetchXML (Valueof node)
Comparison of column was challenging part while executing FetchXML in Dynamics CRM. Microsoft added one new node inside FetchXML condition tag...
Exploring additional filtering capabilities in Sales Forecasting
If you're a seller or manager looking to track sales performance, Dynamics 365's sales forecasting feature is an invaluable tool. In the 2022 ...
Related Record Filtering with the Lookup Dropdown PCF
A new feature has been added to Dataverse's LookupDropdown PCF control that allows for related record filtering. This means that dropdown valu...
D365 CRM Entity Relationships
In this post, we delve into the different types of entity relationships in Microsoft Dynamics 365 CRM and offer insights into how they work. U...