<%*
const dv = app.plugins.plugins["dataview"].api;
const filename = "test";
const query = `TABLE sessionNumber, xp
FROM #dotmm
WHERE contains(attendance, [[Gil Runeswalker|Gil]])
SORT Date asc`;
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);
// append query output to file
//await app.vault.adapter.append(tFile, queryOutput.value);
//const tf = tp.file.find_tfile(tp.file.title);
await app.vault.modify(tFile, tp.file.content + queryOutput.value);
%>