orderBy using eagerAlgorithm #345
Description
Hi! After all, sorry about my english, I speak spanish and I'm using google translate...
I'm traying to use eagerAlgorithm, modify and orderBy in the same query, but the orderBy does not work.
Here is my code:
function jornadaController () {
this.getJornadas = function (params) {
var filterResults = function(queryBuilder) {
if (params != undefined) {
if (params.agencia_id != ''){
if (params.terminal_id == ''){
queryBuilder.where('terminal.agencia_id', params.agencia_id);
} else {
queryBuilder.where('jornadas.terminal_id', params.terminal_id);
}
}
if (params.fecha_desde != '') {
queryBuilder.where('jornadas.fecha', '>=', params.fecha_desde);
}
if (params.fecha_desde != '' && params.fecha_hasta != '') {
queryBuilder.where('jornadas.fecha', '<=', params.fecha_hasta);
}
}
}
return Jornada
.query()
.eagerAlgorithm(Jornada.JoinEagerAlgorithm)
.eager('terminal.agencia')
.modify(filterResults)
.orderBy('jornadas.fecha', 'DESC')
.debug(true)
.then(jornadas => {
return jornadas;
})
.catch(() => {
return false;
});
}
}However, when I run the query that returns .debug () in pgadmin, it works.
I do not know if I'm doing something wrong, or it's a framework issue
Thanks! Matias