57
Hello,
I have a situation where I would like to use FetchXML as Dynamics CRM Source in SSIS package.
I would like to know whether we can pass certain specific value as default in attribute as part of FetchXML?
Something I am looking for is as below.
<fetch top="50" >
<entity name="entity1" >
<attribute name="anything1" alias="a" value="default1" />
<attribute name="anything2" alias="b" value="default2" />
</entity>
</fetch>
*This post is locked for comments
Hi!
You cannot add defaults to the query but when you use the value in the report you can use a formula to show a value if the value is null:
=iif (IsNothing(Fields!name.Value), "Default”, Fields!name.Value)
Hi,
You can use the fetchxml with different operators but it should be in the supported format. you can query in advance find and export fetch or if you are going more advanced than advance find, there is XRMToolBox that helps you in generating fetchxml in the Dynamics supported format.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,307
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
