Changing default sort of activity list view

[nraddatz]

Hi all,

I need to change the default sort of the activity list view (activitymanager.aspx), so that the activities are sorted by start date ascending. I haven't been able to figure out how to do that. Any ideas will be welcome.

Thanks.

[jcouzens]

You need to modify the XML file located here...  SupportFiles\App_Data\ActivitiesViewConfiguration.xml

From there you add/modify groups in the Activities Main View.  Remember that this will get overwritted on an upgrade, so keep a copy somewhere.

Jeremy Couzens

CRMnow

[nraddatz]

Hi Jeremy, thanks for replying.

I see that there's a "ordering" node in that xml file. Is that what i need to modify? What would be the correct syntax? I need to sort by startDate ascending.

Thanks!

[mlaspina]

In version 7.5.4, add the following to line 37 of ActivityViewer.ascx (this is a custom smartpart under Activities):

                <SalesLogix:ConnectionParameter Name="SortOrder" Value="0" />

You should see the following:

        <SalesLogixDataConnection Name="list" Resource="slxdata.ashx/slx/crm/-/activities/activity/all">
            <Parameters>
                <SalesLogix:ConnectionParameter Name="count" Value="true" />
                <SalesLogix:ConnectionParameter Name="SortOrder" Value="0" />
            </Parameters>
        </SalesLogixDataConnection>

Therer is an enumeration of possible sort fields in Sage.SalesLogix.Activity.dll under

    Sage.SalesLogix.Activity -> ActivitySortOrder

[nraddatz]

Hi Mike, thanks a lot for the quick reply! Is there a way to achive this in 7.5.3? Unfortunately i'm working with that version.

[mlaspina]

This should work in 7.5.3 as well as the Activity DLL and the form appear to be the same. 

I'm also looking into the xml config at this point as I need to customize this view for a project I am currently on as well.

[nraddatz]

Hey, thanks for the detailed reply, I will check your suggestions!

Thanks again.

[tagersea]

I am late to the party but I tried to change the default sorting using the ActivitiesViewConfiguration.xml and could not get it to work.  Have no idea why - would love to see a working example.

Instead, I found I had to modify ActivityViewer.ascx.  On line 147 the following block starts:

            connections: {

                list: {

                    resource: "slxdata.ashx/slx/crm/-/activities/activity/all",

                    parameters: { count: "true", sort: "startDate", dir: "ASC" }          

                },

I modified the parameters from only having the count parameter to also include : , sort: "startDate", dir: "ASC"

So far so good.