How would you make a column that indicates whether note contains a certain section?

[johtso]

I'm guessing I need to use a formula column, but it's not obvious what api I'd need to use. Supposedly Obsidian's built in queries allow selecting sections..

[RafaelGB]

Hello!

I just investigate and the Obsidian API for that is metadataCache.

The formula that you need in a javascript is:
isSectionExist.js

function isSectionExist(row,sectionString){
  const headings = app.metadataCache.getFileCache(row.__note__.getFile()).headings;
  return headings.some(h => h.heading===sectionString);
}

module.exports = isSectionExist

Formula: ${db.js.isSectionExist(row,"my section")}

[RafaelGB]

Added to the examples: https://github.com/RafaelGB/obsidian-db-folder/tree/master/docs/examples/rowFormulas