Hi Hristo,

Thanks for the reply.

Sorry forgot to add the platform info, we are on 14.2 with plan to move to 15.1 but not immediately. If you have a solution for 14.2 that would be great.

Regards

Aidan

Hello,

This should work for 14.2:

columnSorting: function (evt, ui) {
 if((ui.owner.option("firstSortDirection") == ui.direction) && ui.owner.grid.dataSource.settings.sorting.expressions.length  != 0) {
  var i, se = [],
  exprs = ui.owner.grid.dataSource.settings.sorting.expressions;
  for (i = 0; i < exprs.length; i++) {
   se.push(exprs[i].fieldName)
  }
  for (i = 0; i < se.length; i++) {
   ui.owner.unsortColumn(se[i], undefined)
  }
  return false;
 }
}

Please test it in your app and let me know if you have further questions, I will be glad to help.

If you wish to sort and unsort the columns programmatically and preserve the class details, you can use the following.  We built a custom UNDO and REDO functionality into the grid and we have two methods to achieve that functionality.  Excuse the terrible formatting.

var _sortColumn = function (fieldName, direction) {
$(.selector).igGridSorting("sortColumn", fieldName, direction);

var colIndex;

$.each($(.selector).igGrid("option", "columns"), function (idx) {
if (fieldName === this.key) {
colIndex = idx;
return false;
}
});

var sorting = $(.selector).data("igGridSorting"), sortStyles = sorting.css, activeHeader;

activeHeader = $(.selector).igGrid("headersTable").find("th").eq(colIndex);
activeHeader.addClass(direction === "asc" ? sortStyles.ascendingColumnHeader : sortStyles.descendingColumnHeader);
activeHeader.addClass(sortStyles.sortableColumnHeaderActive);

sorting._currentActiveHeader = activeHeader;

$(.selector).find("tr td:nth-child(" + (colIndex + 1) + ")").addClass(direction === "asc" ? sortStyles.ascendingColumn : sortStyles.descendingColumn);
};

var _unsortColumn = function () {
$(.selector).data("igGrid").dataSource.settings.sorting.expressions.clear(); // step 1

var settings = $(.selector).data("igGridSorting");

var header = $.grep(settings._headers, function (column) {
return column.header[0].id === id + '_' + settings._curColKey;
});

var columnSetting = $.grep(settings.options.columnSettings, function (columnSetting) {
return columnSetting.columnKey === settings._curColKey;
});

delete columnSetting[0].currentSortDirection; // step 2

var mode = settings.options.mode;
settings.options.mode = "multi"; // step 3

$(.selector).igGridSorting("unsortColumn", header[0].index, header[0].header); // step 4

settings.options.mode = mode; // step 5

$(.selector).igGrid("dataBind"); // step 6
};

Hi,

Thank you for sharing your solution with the other community members ! It is a nice workaround for the sorting mode limiatation. You can also use the suggested above expressions.clear() method if having a column always sorted breaks your scenario in some way.

Please let me know if I may be of any further assistance to you.

Thanks for the update.

In the meantime I adopted your code and this is what I have working now. Posting it so others coming across this post can compare and contrast.

We have a column that is always sorted descending by default, this played well since it allowed the unsort to become a resort on that default column and the CSS and visual clues worked nicely of us.

features: [
{
    name: 'Sorting',
    type: 'remote',
    mode: 'single',
    applySortedColumnCss: false, // remove default sort background color but leave visual clue in header
    columnSorting: function (evt, ui) {
        if ((ui.owner.option("firstSortDirection") == ui.direction) && ui.owner.grid.dataSource.settings.sorting.expressions.length != 0) {
            if (ui.owner.grid.dataSource.settings.sorting.expressions[0].fieldName == ui.columnKey && ui.columnKey != "NameOfYourDefaultSortedColumn") {
            // our grid has a default sort column so sort by it in order to remove current sort.
                $(gridElement).igGridSorting("sortColumn", "NameOfYourDefaultSortedColumn", "descending");
                return false;
            }
        }
        return true;
    }
}]

Thanks again for your help.

Regards

Aidan

Hello Aidan,

I missed to say that the suggested will work only for multi mode sorting and you are using single mode. This is why I modified my code and now it looks like:

columnSorting: function (evt, ui) {
  if((ui.owner.option("firstSortDirection") == ui.direction) && ui.owner.grid.dataSource.settings.sorting.expressions.length  != 0) {
    ui.owner.grid.dataSource.settings.sorting.expressions.clear();
    ui.owner.grid.dataBind();
    $(".ui-iggrid-indicatorcontainer").hide()
    return false;
  }
}

Please find the attached file that you can run and see if this is the behavior you want.

Hi

Unfortunately this doesn't work.

When I asked the question the grid in question had a mode of "multi", so I assumed that was part of the reason the code didn't work.

Since then, the multiple sort requirement was been dropped so I retried this code with a grid with mode = single but it still fails.

1. On the third click (back to firstSortDirection), the unsort does not occur and further clicking has no effect.

2. Clicking on a new / different column heading has no effect but the header gets the "sorted" background color, and the previous column retains its "sorted" background color.

Regards

Aidan