What findOne returns when there is no match?

Question

My nodejs app needs to check if findOne find any match.

  let o = await Model.findOne({where : {name: 'myname'}});
  if (no match in o ) {
  //do something
  } else {
  //do something else
  };

But I did not find any document explaining what findOne returns when there is no match. I know it does not return null or undefined. The return is an object and how I know there is no match.

Answer 1

Here you go , as per the DOC and below example , it will either return the record or null (for no record found) :

// search for attributes
Project.findOne({ where: {title: 'aProject'} }).then(project => {
  // project will be the first entry of the Projects table with the title 'aProject' || null
})

---

So in your case , you can do it like :

let o = await Model.findOne({where : {name: 'myname'}});
if (o) {
    // Record Found
} else {
    // Not Found
};