name | Amplequery |
description | Generate a list of notes that match certain criteria. Can filter by "fields" inside notes as well as tags. |
instructions |  After installing the plugin, type { and you will have 3 new options:1. Amplequery: Field 2. Amplequery: Tag 3. Amplequery: Empty 4. Amplequery: Reference 5. Amplequery: Tag reference "Filter by field" returns a list of notes that match a certain field value, where fields are defined in a table at the top of notes. For performance considerations, this plugin only searches inside notes with a certain tag (as you define in the settings screen). Can be improved once support for inserting tables is added. "Filter by tag" returns a list of notes that match a certain tag query. The "Empty" filter will return a list of notes that are empty, with the option to apply a common tag to all search results. The "Reference" filter will let you select a note and will return all notes that reference the selected note. The "Tag reference" filter will ask for the name of a tag and will return all tasks that reference notes tagged with that tag. |
icon | table-search |
setting | Tag to search in |
repo: https://github.com/lukkes/amplequery
linkTodo
https://www.amplenote.com/plugins/wpTyEKGw2QTMZLFvTFEVqrQZ
refresh button?
List all notes with more than one tag
List all tags with less than 10 notes
When listing empty notes, make sure to include those with completed tasks
linkChange log:
January 11th, 2024
Add new "Reference" option
Add new "Tag reference" option
January 8th, 2024:
Fix empty notes not returning empty notes with completed tasks inside them
December 1st, 2023: Add "search for empty notes" functionality
August 10th, 2023: Fix the tag query not inserting markdown
linkCode block
// Javascript updated 1/11/2024, 6:22:41 PM by Amplenote Plugin Builder from source code within "https://github.com/lukkes/amplequery"
(() => {
// lib/plugin.js
var plugin = {
insertText: {
"Empty": async function(app) {
try {
console.log("Starting amplequery: empty branch...");
const result = await app.prompt(
"Looking for empty notes. Should I mark them for deletion?",
{
inputs: [
{
"type": "radio",
"options": [
{
label: "Mark for deletion",
value: true
},
{
label: "Just show me the results",
value: false
}
]
}
]
}
);
console.log(`User chose mark for deletion option: ${result}`);
app.alert("Please wait. For large notebooks, this operation might take a few minutes and may even make the interface unresponsive.");
let count = 0;
let emptyNoteLinks = [];
for await (const noteHandle of app.filterNotes({ group: "^vault" })) {
count += 1;
let noteContent;
console.log(`Looking at note ${noteHandle.uuid}...`);
try {
noteContent = await app.getNoteContent(noteHandle);
if (noteContent.includes("# Hidden tasks"))
continue;
noteContent = noteContent.slice(0, noteContent.indexOf('# Completed tasks<!-- {"omit":true} -->'));
if (noteContent.trim() === "" || !noteContent.match(/[^\s\\]/mg)) {
console.log(`Found empty note: ${count}`);
emptyNoteLinks.push(` * [${noteHandle.name || "[Untitled note]"}](https://www.amplenote.com/notes/${noteHandle.uuid})`);
if (result)
await app.addNoteTag({ "uuid": noteHandle.uuid }, "-amplequery-to-be-deleted");
}
} catch (err) {
console.log("Caught an error:", err);
console.log("Error type:", err.constructor.name);
if (err instanceof TypeError) {
console.log("Ignoring Vault note because no password was provided by the user...");
continue;
}
}
}
console.log("Writing list...");
await app.context.replaceSelection("* Results:\n" + emptyNoteLinks.join("\n"));
console.log("Success");
} catch (err) {
console.log(err);
await app.alert(err);
}
},
"Field": async function(app) {
try {
let notes = await app.filterNotes({ tag: app.settings["Tag to search in"] });
let attributes = await this._getAllAttributesFromNoteHandles(app, notes);
let field = await app.prompt(`Which field would you like to filter by?
Options: ${Object.keys(attributes).join(", ")}`);
let value = await app.prompt(`What value would you like to filter on?`);
let result = [];
for (const key in attributes[field]) {
if (attributes[field][key] === value) {
result.push(key);
}
}
let noteUUID = await app.createNote("Query results");
await app.insertContent({ uuid: noteUUID }, this._generateMDList(result));
} catch (error) {
app.alert(String(error));
}
},
"Tag": async function(app) {
try {
let tagName = await app.prompt("What tag query to filter on?");
let notes = await app.filterNotes({ tag: tagName });
const self = this;
let noteUUID = await app.createNote("Query results");
let result = "- Results\n" + this._generateMDList(notes.map((obj) => self._createMDLinkFromNoteHandle(obj)), 1);
await app.insertContent(
{ uuid: noteUUID },
result
);
await app.context.replaceSelection(result);
} catch (error) {
app.alert(String(error));
}
},
"Reference": async function(app) {
try {
let note = await app.prompt(
"Choose a note you want to get all the references for",
{ inputs: [{ label: "Note reference", type: "note" }] }
);
if (note) {
let references = await app.getNoteBacklinks(note);
const self = this;
let result = "- Results\n" + this._generateMDList(references.map((obj) => self._createMDLinkFromNoteHandle(obj)), 1);
await app.context.replaceSelection(result);
}
} catch (err) {
console.log(err);
await app.alert(err);
}
},
"Tag Reference": async function(app) {
try {
let tag = await app.prompt(
"Enter the name of the tag you want to find all tag references for",
{ inputs: [{ label: "Tag reference", type: "text", placeholder: "Tag name" }] }
);
if (!tag)
return false;
tag = tag.trim();
console.log("Fetching all notes with chosen tag...");
let tagNotes = await app.filterNotes({ tag });
if (!tagNotes)
return false;
let result = [];
for (let note of tagNotes) {
console.log(`Fetching all tasks that reference ${note.name}...`);
let refs = await app.getNoteBacklinks(note);
for (let ref of refs) {
let refTasks = await app.getNoteTasks(ref);
let taggedTasks = await this._filterTasksByInlineTag(app, refTasks, note);
result = result.concat(await Promise.all(taggedTasks.map(async (task) => {
let note2 = await app.findNote({ uuid: task.noteUUID });
return {
note: note2,
task
};
})));
}
}
console.log("Building results...");
result = `- Results
` + this._generateMDList(
await Promise.all(result.map(async (item) => {
return `Source note: ${this._createMDLinkFromNoteHandle(item.note)}
\\
${item.task.content}`;
})),
1,
"- []"
);
await app.context.replaceSelection(result);
console.log("Success!");
} catch (err) {
console.log(err);
await app.alert(err);
}
}
},
async _filterTasksByInlineTag(app, taskList, inlineTag) {
let result = [];
for (let task of taskList) {
console.log(task);
let content = task.content;
console.log(content);
console.log(await app.getNoteURL(inlineTag));
if (content.match(new RegExp(`\\[.*\\]\\(${await app.getNoteURL(inlineTag)}\\)`))) {
result.push(task);
}
}
return result;
},
async _getAllAttributesFromNoteHandles(app, notes) {
let attributes = {};
for (let i = 0; i < notes.length; i++) {
let note = notes[i];
let contents = await app.getNoteContent({ uuid: note.uuid });
const _attributes = this._getDictFromTable(contents);
for (const key in _attributes) {
if (!attributes[key]) {
attributes[key] = {};
}
attributes[key][this._createMDLinkFromNoteHandle(note)] = _attributes[key];
}
}
return attributes;
},
_createMDLinkFromNoteHandle(noteHandle) {
return `[${noteHandle.name}](https://www.amplenote.com/notes/${noteHandle.uuid})`;
},
_generateMDList(input, indent = 0, type = "-") {
return input.map((item) => " ".repeat(indent) + `${type} ${item}`).join("\n");
},
_getDictFromTable(input) {
let result = {};
const lines = input.split("\n");
const table_lines = lines.filter((str) => str.startsWith("|"));
for (let i = 2; i < table_lines.length; i++) {
const [_, key, value, ...rest] = table_lines[i].split("|");
result[key] = value;
}
return result;
},
_generateMarkdownTable(data) {
const notes = Array.from(new Set(Object.values(data).flatMap(Object.keys)));
const attributes = Object.keys(data);
let table = "| " + ["Note", ...attributes].join(" | ") + " |\n";
table += "| " + attributes.map((_) => "---").join(" | ") + " |\n";
notes.forEach((note) => {
let row = "| " + note + " ";
attributes.forEach((attr) => {
row += "| " + (data[attr][note] || "-") + " ";
});
row += "|\n";
table += row;
});
return table;
}
};
var plugin_default = plugin;
return plugin;
})()