search

rappen / FetchXMLBuilder

FetchXML Builder for XrmToolBox and Microsoft Dynamics 365 / CRM
https://fetchxmlbuilder.com/
GNU General Public License v3.0
135 stars 56 forks source link

Column compare feature using non text fields #351

Closed David161069 closed 4 years ago

David161069 commented 4 years ago

I tired to use the Fetch XML Builder to compare 2 date fields. I get an error. The query builder is asking for something in the 'value' field, but I only want to use the 'value of' field. Text fields work fine, but option sets, whole number and date fields don't. I understand these field types are supported by Microsoft when doing column compare in Fetch XML. Do you plan to support these field types in the Fetch XML Builder. BTW, love your work. FetchXMLBuilderError

MarkMpn commented 4 years ago

There is a fix for this ready in #349, hopefully this will be in the next release.

palashbd commented 4 years ago

image How to eliminate this error!

MarkMpn commented 4 years ago

@palashbd What version of D365 are you running this against? Online or on-prem?

palashbd commented 4 years ago

@MarkMpn v1.2020.6.40

MarkMpn commented 4 years ago

@palashbd Sorry, I meant the version of D365, not XrmToolBox or FetchXML Builder. In the D365 web interface, click the gearwheel icon in the top right, then About. For example, when I do this I see "Version 1710 (9.1.0.20748) online"

MarkMpn commented 4 years ago

OK, this feature is only available in online versions at the moment. I'd expect it to be in the next major on-premise release.