Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. models.Convos.findAll({
  2. include: [
  3. {
  4. model: models.Messages,
  5. as: "last_message",
  6. order: [ [ 'created_at', 'DESC' ]],
  7. limit: 1,
  8. }
  9. ],
  10. where:{
  11. [Op.or]: [
  12. {
  13. sender_id: req.decoded.id
  14. },
  15. {
  16. recipient_id: req.decoded.id
  17. }
  18. ],
  19. },
  20. )}
  21.  
  22. order: [
  23. [{model: models.Messages, as: 'last_message'}, 'created_at', 'DESC'],
  24. ],
  25.  
  26. `Unhandled rejection SequelizeDatabaseError: missing FROM-clause entry for table "last_message"`
  27.  
  28. Sequelize.literal("`last_message`.`id` IS NOT NULL")
  29.  
  30.  
  31. '$models.Messages.id$': { [Op.ne]: null },
  32.  
  33. Sequelize.fn("COUNT", Sequelize.col("last_message")): { [Op.gt]: 0 }
  34. '$last_message.id$': { [Op.ne]: null }
  35.  
  36. $last_message.id$`: {
  37. [Op.ne]: null
  38. }
  39.  
  40. having: Sequelize.where(Sequelize.fn('COUNT', Sequelize.col('$last_message.id$')), '>=', 0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement