Order tableviewrow by calculated distance

Hi guys,

can anyone help me out with ordering tableviewrows by calculated distance.

I've got a while loop where I fetch all the data from my database. Inside my while loop I calculate the distance for every place inside my database based on their fixed coordinates and the user's location.

var rows = db.execute('SELECT DISTINCT p.placesID, p.name, p.longitude, p.latitude FROM places p, categories c, places_categories pc WHERE pc.categoryID="' + hasCategoryID + '"AND pc.placesID = p.placesID ORDER BY name');
var dataArray = [];
while (rows.isValidRow()) {
    var row = Titanium.UI.createTableViewRow({
        className:'placesRow',
        placesID:rows.fieldByName('placesID'),
        title:rows.fieldByName('name'),
        rowDistance:' ',
    });
    var fixLat = rows.fieldByName('latitude');
    var fixLon = rows.fieldByName('longitude');
    var longitude = e.coords.longitude;
    var latitude = e.coords.latitude;
    if (fixLon==='' || fixLat===''){
        // If coordinates are not inside the database don't calculate distance
     } else {
        // Here I calculate the distance inside a label and add that label to the tableviewrow
        var distance =  Titanium.UI.createLabel({
            text:getDistance(fixLat,fixLon,latitude,longitude).toFixed(0) + 'm',
            distance:getDistance(fixLat,fixLon,latitude,longitude),
        });
        // Here I pass the value of the distance to rowDistance
        row.rowDistance = distance.distance;
        row.add(distance);
    }
    dataArray.push(row);
    rows.next();
    Ti.API.info(points);
};
tableview.setData(dataArray);
rows.close();
db.close();

Thanks!

I think there are two options. You can make the calculation in SQLite.

var rows = db.execute('SELECT DISTINCT p.placesID, p.name, p.longitude, p.latitude FROM places p, categories c, places_categories pc WHERE pc.categoryID="' + hasCategoryID + '"AND pc.placesID = p.placesID ORDER BY SQRT((p.latitude - ' + latitude + ')^2 - (p.longitude - ' + longitude +  ')^2) ');

var rows = db.execute('<your query>')
 
rows = _.sortBy(rows, function(row) { 
    return getDistance(rows.fieldByName('latitude'),
            rows.fieldByName('longitude'),latitude,longitude) 
});
 
tableview.setData(rows);