<%* const dv = app.plugins.plugins["dataview"].api; //const filename = "test"; //const openPublishPanel = app.commands.commands["publish:view-changes"].callback; const fileAndQuery = new Map([ [ "Magnus XP", 'TABLE sessionNumber, xp FROM #dotmm WHERE contains(attendance, [[Gil Runeswalker|Gil]]) SORT Date asc', ], [ "Vladis XP", 'TABLE WITHOUT ID sum(map(rows, (r) => default(r.xp, 5000))) AS "Vladis: Total XP" FROM #dotmm WHERE contains(attendance, [[Vladis]]) GROUP BY True', ], ]); await fileAndQuery.forEach(async (query, filename) => { const tFile = tp.file.find_tfile(filename); const queryOutput = await dv.queryMarkdown(query); // write query output to file await app.vault.modify(tFile, queryOutput.value); }); %>