Node JS - Function with Return does not pass data

Question

I’m trying to make a very basic API, to learn, but I can’t understand why the return of a function that takes data from BD does not return it to the other module.

I’m wearing Knex and ES6: This module (Controle) calls the function AtividadesTodas(), that is in the module models:

// Seleciona todas as atividades
    async todosRegs(req, res){
        var listaAtiv = await Atividades.AtividadesTodas();
        if(listaAtiv != undefined){
            res.json(listaAtiv);
        }else{
            console.log('lista vazia');
        }
        
    }

In the module Models, in this function, the data is stored in the variable data, so much that they can be displayed on the console, but apparently these data do not return, as it always falls on else, or is variable undefined:

 async AtividadesTodas(){
        await knex('Atividades').select('AtividadeDesc').orderBy('AtividadeDesc').then(data => {
            console.log(data);
            return data;
        }).catch(err => {
            console.log(err);            
        });

Answer 1

The correct and used way is as follows by returning the Promise and in the Node resolve and bring the result, example:

AtividadesTodas() {
    return knex('Atividades').select('AtividadeDesc').orderBy('AtividadeDesc');
}

and in the Node:

async todosRegs(req, res) {
    try {
        const listaAtiv = await Atividades.AtividadesTodas();
        if(listaAtiv != undefined) {
            res.json(listaAtiv);
        } else {
            console.log('lista vazia');
        }   
    } catch (e) {
       // error
       console.log(e);
    }
}

Get a good read on that answer: When "Return" is different from "Return await" in an asynchronous function in Javascript?