Sorting a store when record field with no value

[claritee]

Hello,

I have been adding sorters on a store and noticed that if a record does not have a value for a field remains at the top of the sort.

Just wondering is there a way to order these records to the end of the list?

--- The Store ---
Ext.define('MyApp.store.PropertySummaries', {
    extend: 'Ext.data.Store',
    xtype: 'PropertySummaries',


    config: {
        model: 'MyApp.model.PropertySummary',
        sorters: ['propertyName', 'minPrice', 'maxAdults', 'consumerRating']
    }
});
....

--- called by ---
theStore.sort('consumerRating', 'DESC');

In this case if there is no consumerRating, I want the record to be at the bottom of the list.

Thanks in advance!

[mitchellsimoens]

You could add your own Ext.util.Sorter with a custom sortFn to the store's sorters.

[claritee]

Thanks for the quick reply!

I tried with the below and that worked

theStore.sort([{
    direction: 'ASC',
    sorterFn: function(o1, o2) {
        return compare(o1.data.consumerRating, o2.data.consumerRating);
    }
}]);

....



theStore.sort([{
    direction: 'DESC',
    sorterFn: function(o1, o2) {
        return compare(o1.data.consumerRating, o2.data.consumerRating);
    }
}]);


.... // etc ....

....
// not the most elegant
function compare(value1, value2) {
    if (!value1 || value1 == '') {
        return -1;
    }
    if (!value2 || value2 == '') {
        return 1;
    }
    if (value1 > value2) {
        return 1;
    }
    if (value1 == value2) {
        return 0;
    }
    return -1;
}

I was wondering if there is a way to define multiple sorterFns?
I tried to define multiple sorter functions but I think there is an error somewhere as the sorterFn isn't getting invoked (or default one is being invoked)

Ext.define('StayzApp.store.PropertySummaries', {
    extend: 'Ext.data.Store',
    xtype: 'PropertySummaries',


    config: {
        model: 'StayzApp.model.PropertySummary',
        sorters: [
            {property : 'propertyName'},
            {property : 'minPrice'}, // TODO also define custom sorterFn
            {property : 'maxAdults'}, // TODO also define custom sorterFn
            {
                property : 'consumerRating',
                sorterFn: function(o1, o2) {
                    return compare(o1.data.consumerRating, o2.data.consumerRating);
                }
            }
        ]
    }
});

--- and to invoke ---

theStore.sort('consumerRating', 'ASC'); or
theStore.sort('consumerRating', 'DESC');

Thanks for your help