# Vladis Total XP:
<%*
const dv = app.plugins.plugins["dataview"].api;
const filename = "test";
const query = `TABLE WITHOUT ID sum(map(rows, (r) => default(r.xp, 5000))) AS "Vladis: Total XP"
FROM #dotmm
WHERE contains(attendance, [[Gil Runeswalker|Gil]])
GROUP BY True`;
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);
%>