Need to get executed sql query after find/ findall

[fabuhelow]

Hi,

I'm trying to get executed sql query after fetched the result, so is it possible to get query statement.

E.g.

Model.findAll(...).then(function(data)
{

// need to get executed sql query "select id,name from model where id = 12";

});

Any help please.

Thanks,

[janmeier]

findAll({ ..., logging: function (sql) ... })

Closing this issue, since it is neither a bug report nor a feature request.

For general sequelize questions, please use Slack, StackOverflow or Google groups.

[fabuhelow]

Thanks janmeier,

But i need the query inside then directive, so is it possible to pass it inside .then callback function ?

[janmeier]

Have the logging function store it in a variable variable

var sql; 
findAll({ ..., logging: function (sql) ... }).then(function () {
 // do something with sql
});