Listing headings with a partial text match

What I’m trying to do

  • I have daily notes
  • I have project notes
  • In the daily notes, I have a heading for all meetings, for example TPS Reports: Research, or TPS Reports: Production Issues

What I want is to have a query for the project notes that shows me a list of all meetings with TPS Reports in its heading:


  • Research (link to daily note)
  • Production Issues (link to daily note)

Things I have tried

WHERE file.lists
FLATTEN file.lists as L
WHERE meta(L.section).subpath = "TPS Reports" and contains(file.path, "001 Dailies")

But this query looks up an exact text match, I want partial text match.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.