<%* const dv = app.plugins.plugins[“dataview”].api;
const queries = [
{
file: “最近更新”,
query: TABLE WITHOUT ID file.link AS Note, dateformat(file.mtime, "ff") AS Modified FROM "" WHERE publish SORT file.mtime desc LIMIT 10 ,
},
];
for (const item of queries) { const { file, query } = item; try { const tFile = tp.file.find_tfile(file); const queryOutput = await dv.queryMarkdown(query); const fileContent = `--- publish: true
{queryOutput.value}`; // write query output to file await app.vault.modify(tFile, fileContent); } catch (err) { new Notice(`⚠️ ERROR updating! Check console. Skipped file: {filename}\nError: ${err}`, 0); }
} %>