slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New Thread

View: Search:

Author

Thread: Set Default sort order in datagrid?

Dan Carvin
Posts: 227

Set Default sort order in datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Nov 08 2:05 PM

Is there a way to change the default sort order on a datagrid in 7.5 Web?

For example, have AccountTickets show the most recent tickets first instead of the oldest first?

I'm not seeing a way to do that in AA.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Set Default sort order in datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Nov 08 8:00 AM

Groups are still part of the Windows World of SalesLogix.

You need to go into the SalesLogix Windows side (Tickets) and make the changes there. - This is true even for the latest release (v7.5) as well.
--
RJLedger - www.SlxWizard.com

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Set Default sort order in datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Nov 08 8:11 AM

Quote:

Originally posted by Dan Carvin

Is there a way to change the default sort order on a datagrid in 7.5 Web?

For example, have AccountTickets show the most recent tickets first instead of the oldest first?

I'm not seeing a way to do that in AA.

OOPS.. Ignore my 1st response to your post.. was thinking about groups/listviews and missed that you are looking at a "tab".

The "collection editor" has a couple of properties that you need to look at:
a - IsSortable
b - SortField property
You want to look at the DataGrid and not the recordsource to see this.
--
RJLedger - www.SlxWizard.com

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Set Default sort order in datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Nov 08 11:03 AM

I have an article that will walk you through this: http://customerfx.com/pages/crmdeveloper/2008/03/07/setting-the-default-sort-for-a-datagrid-in-saleslogix-web.aspx

-Ryan

[Reply][Quote]

Ken Poggensee
Posts: 71

Re: Set Default sort order in datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Feb 09 5:53 PM

Does this still work in 7.5? I try it and it doesnt seem to set the default sort...

grdAccountTickets.Sort("ReceivedDate", SortDirection.Descending);

--Ken--

[Reply][Quote]

Mike LaSpina
Posts: 116

Re: Set Default sort order in datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Feb 09 6:02 PM

This works fine in 7.5.0. However, it seems to have stopped working in 7.5.1. The workaround for the time being in 7.5.1 is to take the form custom and add a default sort directly to the grid's properties:

CurrentSortExpression="ReceivedDate" CurrentSortDirection="Descending"

[Reply][Quote]

Ken Poggensee
Posts: 71

Re: Set Default sort order in datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Feb 09 6:29 PM

That worked.

Just a pain because now I cant open the form to and add a column to the grid. I have to go into the ascx and resx file and add the columns through code. I’m not complaining though (ok maybe I am) because at least now I have a solution.

Thanks Mike.

[Reply][Quote]

Ken Poggensee
Posts: 71

Re: Set Default sort order in datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Feb 09 1:01 PM

Although this solution does set the default sort, there seems to be something else wacky going on that effects the OnRowSelect with ‘sort’. I have a script that goes out and runs for a selected row. With the sort enabled, when I select the row (row select column), it grabs the wrong record.

If I watch closely I can see that when I press the select column link, it re-sorts the grid (different than my default sort. No ryhm or reason to the new sort) and then tries to grab the row from the same position in the grid, which is now not the same row that originally selected.

Any thoughts before I start chasing this down through VS?

--Ken--

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Set Default sort order in datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Mar 09 9:49 AM

Quote:

Originally posted by Ken Poggensee

Does this still work in 7.5? I try it and it doesnt seem to set the default sort...

grdAccountTickets.Sort("ReceivedDate", SortDirection.Descending);

--Ken--

Hey Ken,

I've updated my original post on this to show how to do it with the changes in 7.5. See http://customerfx.com/pages/crmdeveloper/2009/03/26/setting-the-default-sort-for-a-datagrid-in-saleslogix-web-revisited.aspx

[Reply][Quote]

RJ Samp
Posts: 973

Re: Set Default sort order in datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Jan 12 12:32 PM

Still getting errors in 7.5.4 for the AccountContacts grid......and still no way to sort by two or more columns?

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/28/2025 7:56:54 AM