Tabs Config / FetchXML & Fields

Topics: Configuration
Oct 27, 2014 at 1:12 PM
Hello!

First of all - this solution is fantastic!! Got it imported with a great excitement! :-)
I have followed the steps in the guideline document however when I added the web resource to the form at the end it does not retrieve any records (whilst clearly there are some falling in the particular criteria).
Trying to work out if my fetchXML is incorrect, or I'm missing something at the fields part..or fetch isn't triggered at all. perhaps there's a setting somewhere I haven't ticked.. :-(
Created Group - Account, 2 Tabs - Top Opportunities and Top Projects (custom entity), added to the Account Form.

Here are my settings for the Opportunity tab:

Fields:

OnClick | OpenForm | clickAction| opportunityid
Attribute | None | title | name
Attribute | None | zone1Text | statuscode
Attribute | None | zone2Text | estimatedvalue
Attribute | None | zone3Text | a.fullname
Css | Equals | cssClass | opportunityratingcode; 1 = hot; 2 = warm; 3 = cold;
Icon | Equals | iconUrl | https://org.crm4.dynamics.com//WebResources/prefiex_top_opportunity_icon_s

FetchXML

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
<entity name="opportunity" >
    <attribute name="name" />
    <attribute name="estimatedvalue" />
    <attribute name="statuscode" />
    <attribute name="opportunityid" />
    <attribute name="opportunityratingcode" />
    <order attribute="name" descending="false" />
    <filter type="and" >
        <condition attribute="parentaccountid" operator="eq" value="@id" />
        <condition attribute="estimatedvalue" operator="gt" value="20000" />
    </filter>
    </link-entity>
    <link-entity name="systemuser" from="systemuserid" to="owninguser" visible="false" link-type="outer" alias="a" >
        <attribute name="fullname" />
    </link-entity>
</entity>
</fetch>