views
Plugin: Amplequery
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?
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'));
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;
})()