locked
XML Fetch Order Command, Not Sorting RRS feed

  • Question

  • I have a CRM 2011 update 6 on prem installation.

    I am doing the following fetch for a chart and I can't get the result set to sort on any field.  Ideally I want it to sort on the aggregate_column field. It does not matter what field I use to sort with it reders the same result.

    I have a copy of my fetch below.

    Thanks

          <fetchcollection>

            <fetch mapping="logical" aggregate="true">

              <entity name="account">

                <attribute alias="aggregate_column" name="ee_segment" aggregate="countcolumn" />

                <attribute name="ee_segment" groupby="true" alias="segment"  />

                <order alias="segment" descending="false" />

              </entity>

            </fetch>

          </fetchcollection>


    Scott Clancy

    Tuesday, July 3, 2012 11:09 PM

All replies

  • HI Scott,

                    Did you try creating the query first with the Advance Find tool and then download the FetchXML from there?

    Any way you can also try sorting by attribute as follows

    <order descending="false" attribute="ee_segment"/>


    Regards,
    Damian Sinay

    Wednesday, July 4, 2012 1:54 AM