Support data pre-filtering attributes

[davidlb]

I use FetchXML builder to build my FetchXml query to use in my reports. It would be nice to support the 2 data pre-filtering attributes : https://technet.microsoft.com/en-us/library/dn531099(v=crm.7).aspx#Fetch_basedPre_filtering

Thanks!

[rappen]

Good idea! Will have a look at that, unless you feel like contributing...? ;)

[mscottsewell]

Oh yeah. +1

[rappen]

Does anyone have any idea where this is defined? The fetch.xsd schema does not appear to support it, so validation of a pre-filtered query against the schema would fail.

[mscottsewell]

I've reached out to the team to ask. Will let you know what I find.

In FetchXML for SSRS reporting we can use prefiltering by adding options to the FetchXML query: https://technet.microsoft.com/en-us/library/dn531099(v=crm.7).aspx#Fetch_basedPre_filtering

However those extensions aren’t documented in the fetch.xsd schema and consequently, validation of a correctly built pre-filtered query against the documented schema would always fail.

Is there an XSD that includes the prefiltering options as valid?

[rappen]

:+1:

[mscottsewell]

Jim D. has confirmed and submitted it to the team as a bug in the documentation - it will be a few months before it completes the cycle and arrives in the published XSD - until then I would assume it's a 'known limitation' - (or you can override/edit the XSD yourself to allow for the exception.)

[davidlb]

Ok, thanks :)

[scottdurow]

For me - probably the biggest use I have for the FetchXml Builder is authoring queries for reports - so I'd really like it just strip out these attributes when running the query.

[rappen]

Jim D confirmed it is now fixed in the XSD and docs for v9 updated, so it should be possible to implement this with the tech supporting it! https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/org-service/fetchxml-schema