DataviewJS Snippet Showcase

renfield · August 17, 2021, 7:26pm

Supergenial! Works like a charm - thanks a lot!
Now I enjoy my new TOC a lot. Way back, in Notion, I used a similar way to sort notes by date of modification. It just helps me to keep an eye on rarely used files.

trav · August 19, 2021, 4:52pm

wow thank you so much for this, it’s exactly what I’m looking for. Though I’m not quite sure how to implement. I’ve got dataview installed (have been using it for leaflet maps).

Can I have this function just look at a folder instead of using a searchterm? Or at least how do I identify a note as being ‘People’ so that it will show up on the birthday list? Also, where do I put the dataviewjs code?

thanks so much

Moonbase59 · August 19, 2021, 5:34pm

Happy you like it!

For searchterm:, you can use all valid Dataview search terms. In this case, it looks in the folder “People” and its subfolders.

This DataviewJS code usually goes in an extra note, like “Upcoming Birthdays”, but you could it include elsewhere of course.

HTH

grey5307 · August 20, 2021, 3:08am

Thank you so much for this script! It’s making it much easier for me to set up my hotkeys and keeping them on the side as I figure out my workflow.

Is there an easy way to omit any of the commands not assigned with any hotkeys? (get rid of all the rows containing “-”?)

I don’t know any javascript. Managed to figure out some basics like swapping out Mac commands and removing the command ID column, but struggling to find a solution for the above.

Moonbase59 · August 20, 2021, 4:41am

Thanks for your kind words, appreciate it! You can use the “Commands sorted by assigned hotkey” part alone, it will only show the commands with hotkeys, not the complete command list. Or put the two parts in two notes

samlewis0602 · September 2, 2021, 9:27pm

Hey everyone! I just wanted to share that my plugin CustomJS is now available on the community store. It allows you to write and reuse javascript across Obsidian, and works on desktop and mobile. It pairs great with Dataview, which is my primary use case. See the Advanced Example section of the README for how I’m using it with dataview to manage my tasks.

robertofgama · September 6, 2021, 2:03pm

Hello guys, this is my snippet, its finds all my tasks from my notes on my work folder.

but i like to ask you a little help, because i dont know how to order the result by file name.

If any of you could help me i will be very gratefull.

`dv.taskList(dv.pages('"Notes/Work"').file.tasks
.where(t => !t.completed))`

Moonbase59 · September 6, 2021, 9:41pm

You need to sort before checking the tasks.

Personally, I like to sort on full path:

```dataviewjs
dv.taskList(dv.pages('"Notes/Work"')
.sort(p => p.file.path, 'asc')
.file.tasks
.where(t => !t.completed))
```

although the list can be a little confusing with tasks, because only the file name is shown but it is still sorted on full path name (including folder names).

If you want to sort on file name only, you can substitute the above sort line with:

.sort(p => p.file.name, 'asc')

robertofgama · September 9, 2021, 12:48pm

Thanks @Moonbase59, helped me alot, works perfectly.

I never understand these parameters like p =>, t =>. I don’t found nothing on documentation, i know that t => is for tasks, and p => is for path?
What other parameters like those exist?

samlewis0602 · September 9, 2021, 10:59pm

Those are not specific to dataview or Obsidian, those are javascript arrow functions. The parameter can be named anything you want, you could use banana => if you wanted to

Moonbase59 · September 10, 2021, 12:28am

lazy me, I’d still use b => instead of banana =>

Here’s a little explanation on the MDN for those who don’t use these often.

robertofgama · September 10, 2021, 6:55pm

thank you again, this will help me to create my codes, i am not a programmer, sometimes it’s seems to be a little confusing to me.

elwc · September 14, 2021, 2:39am

I want to create a dataview to show me the notes that has mutual tags as my current file. The code below works for a note with two tags. But there are a few things that I can’t achieve:

I do not want to see all the tags in the Tags column; I only want to see the mutual tags there.
I want to have a generic code that can be applied to every note whether the note has one tag or two tags or 10 tags.

table Tags
Where contains(file.tags, this.file.tags[0]) or contains(file.tags, this.file.tags[1])
sort tags

And so I decided to venture into dataviewjs.

You guys are awesome and dataviewjs’ possibilities are enormous. I read through every single post here and tried so hard but I still couldn’t find out how to do what I want. Anyone is able to help me out? Thanks in advance!

ZeeKhar · September 18, 2021, 2:26am

I did this script that can sort columns in dataviewJS by clicking on them.
Hope that help!

// Render the table
dv.table(["Paper","Title", "Year", "📚", "✒️","🧠","Updated"], dv.pages("#LiteratureNote")
	.where(b=>b.file.folder == ("Zettelkasten"))
    .sort(b => b.file.mtime, 'desc')
    .map(b => [
	"[[" + b.file.name + "|" + (b.file.aliases[1] || b.file.aliases[0]) + "]]", 
	
b.file.aliases[0],
b.Year,
b.completion_reading,
b.completion_note,
b.paper_understanding,
b.file.mtime.toFormat('yyyy-LL-dd T')
]))
	
// Sort Script	
	
// Source https://stackoverflow.com/questions/14267781/sorting-html-table-with-javascript
const getCellValue = (tr, idx) => tr.children[idx].innerText || tr.children[idx].textContent;

const comparer = (idx, asc) => (a, b) => ((v1, v2) => 
    v1 !== '' && v2 !== '' && !isNaN(v1) && !isNaN(v2) ? v1 - v2 : v1.toString().localeCompare(v2,undefined, {numeric: true})
    )(getCellValue(asc ? a : b, idx), getCellValue(asc ? b : a, idx));

// do the work...
document.querySelectorAll('th').forEach(th => th.style.cursor = "pointer");

document.querySelectorAll('th').forEach(th => th.addEventListener('click', (() => {
  const table = th.closest('table');
  const tbody = table.querySelector('tbody');
  Array.from(tbody.querySelectorAll('tr'))
    .sort(comparer(Array.from(th.parentNode.children).indexOf(th), this.asc = !this.asc))
    .forEach(tr => tbody.appendChild(tr) );
})));

bepl · September 20, 2021, 7:33am

What can I say? I have inserted the code into my table code. And: it works just like that! This is a really great thing, finally I have an overview of my very long tables. Thank you!

pseudometa · September 28, 2021, 10:40am

I created a small snippet to filter tasks on a page based on inclusion/exclusion of multiple tags. It’s pretty generic, so I thought I might share it.

%%
include:: tag1
exclude:: tag2
onlyUncompleted:: false
%%

```dataviewjs
const source = dv.current();
const include = source.include;
const exclude = source.exclude;
const onlyUncompleted = source.onlyUncompleted;
let tasks = source.file.tasks;

// include
if (include != undefined) {
    let includeTags = include.replace(/[,#]/g,"").split(" ");
    let includedTasks = [];
    includeTags.forEach (tag => {
        let filteredTasks = tasks.filter (t => t.text.includes ("#" + tag));
        includedTasks.push (...filteredTasks);
    });
    tasks = includedTasks;
}

// exclude
if (exclude != undefined) {
    let excludeTags = exclude.replace(/[,#]/g,"").split(" ");
    excludeTags.forEach (tag => {
        tasks = tasks.filter (t => !t.text.includes ("#" + tag));
    });
}

//completed
if (onlyUncompleted) tasks = tasks.filter (t => !t.completed)

dv.taskList(tasks, false);
```

Billy_McSkintos · September 29, 2021, 4:10am

Still trying to get the hang of DataView and DataViewJS is over my head. However, I am struggling to create a simple query of “Incomplete Tasks in the current note”

I want to be able to identify all the tasks in one place that exist in the note I have open - no hardcoded values - just this note.

If this give me all incomplete tasks in all notes:

dv.taskList(dv.pages().file.tasks.where(t => !t.completed))

How do I get only the incomplete tasks in the current note?

gede · September 29, 2021, 7:10am

you can access the current file with dv.current() so just replace dv.pages() with dv.current().

Billy_McSkintos · September 29, 2021, 2:54pm

Thank you. However, with:

\```dataviewjs
dv.taskList(dv.current().file.tasks.where(t => !t.completed));
```\

I get an error:

Evaluation Error: TypeError: dv.current(...).file.tasks.where is not a function
    at eval (eval at <anonymous> (eval at <anonymous> (app://obsidian.md/app.js:1:1215379)), <anonymous>:1:75)
    at DataviewInlineApi.eval (eval at <anonymous> (app://obsidian.md/app.js:1:1215379), <anonymous>:12599:16)
    at evalInContext (eval at <anonymous> (app://obsidian.md/app.js:1:1215379), <anonymous>:12600:7)
    at eval (eval at <anonymous> (app://obsidian.md/app.js:1:1215379), <anonymous>:12611:36)
    at Generator.next (<anonymous>)
    at eval (eval at <anonymous> (app://obsidian.md/app.js:1:1215379), <anonymous>:26:71)
    at new Promise (<anonymous>)
    at __awaiter (eval at <anonymous> (app://obsidian.md/app.js:1:1215379), <anonymous>:22:12)
    at asyncEvalInContext (eval at <anonymous> (app://obsidian.md/app.js:1:1215379), <anonymous>:12606:12)
    at DataviewJSRenderer.eval (eval at <anonymous> (app://obsidian.md/app.js:1:1215379), <anonymous>:13133:23)

pseudometa · September 30, 2021, 10:24am

for some reason, where does not seem to work anymore, but the equivalent filter does:

dv.taskList(dv.current().file.tasks.filter(t => !t.completed));