https://knexjs.org/guide/query-builder.html#knex
module.exports = (options = {}) => { return async context => { context.params.query = { // added by mark ...context.params.query, // added by mark $select: ['clientStimwordNotes'] // added by mark } // added by mark return context; }; };to completely rewrite the query:
module.exports = (options = {}) => {
return async context => {
const query = context.service.createQuery(context.params);
const knexClient = context.app.get(‘knexClient’) ;
query .clear(‘select’)
.select ( ‘col_4’
, { ‘my Column’ , `col0’ }
, knexClient.raw(“CONCAT AS col1_2”)
)
.distinct()
.orderBy(‘languageNormsName’)
;
context.params.knex = query
return context;
};
};
notice the THREE different styles of selection.