You should see it on the Community Plugins page:
Haha I’m not even sure what I mean! I don’t know too much about cmi, but perhaps there is some integration to be found with dataview
It shows now, sometimes searching in obsidian plugins don’t show anything for some reaon.
That is very cool, but it doesn’t work for me for some reason (I edited the url), maybe it works only on linux
I’m on windows.
Assuming you want to use command line, make sure you name the codeblock
```sh
ls
```
These are the settings I have in Snippets settings
"sh": {
"template": "{{src}}",
"showModal": true,
"appendOutputContents": true,
"showRunButtonInPreview": true
}
thanks, it works now. I have to work with it more. I was thinking it is Linux only for some reason before, very happy to learn that it is now
You can use dataview to do rollups, several levels deep.
Example:
```dataview
table start-date, end-date, quarters, quarters.months.weeks.start-date
from #years
sort date asc
In my pages tagged #years I have a list of related quarters in link format:
Likewise, in my quarters pages I have a list of linked months:
And so on. The above query will produce a column that has all the start dates of all the weeks that are related to the months that are related to the quarters that are related to the year for that row.
Small example:
This isn’t maybe the most useful example, but I wanted to show a few levels of depth. Anyone familiar with rollups knows this opens up some really cool stuff, especially for reviews and such!
This is awesome! I really like how you can dive deep into it
I see blacksmithgu has just added more support weeks:
Perhaps you can use this to reduce some of the noise in how the dates are rendered on the right side there.
Good point! I’ll need to check those out. Lots of new goodies this week
I’m not sure if this way always possible, or just recently added, but you can create indented lists when a note’s field is an array.
For example, show a list
of all literature notes, with a sublist of authors from each:
list authors from #LitNote
This feature seems to have alot of potential, but I don’t think the example in the docs works as at 2021-03-24. The following is what I found to work.
You can add strings and fields to the result of a list
query.
For example, in each university assignment, I have the type
of assignment, as well as a field intensity
with a green, yellow, or red square indicating how much effort will be required of me:
---
intensity:
type: ‘Essay’
---
Then, using +
as a concatenation operator, you can write a string containing field values:
list "This much work " + intensity + " required for the " + type
from #Assignment
You can now also very easily create a list of backlinks:
list from [[note]] // List all notes which link to [[note]]
Or an index of all links leaving a note:
list from outgoing([[note]]) // List all notes that [[note]] links to
Coupled with the Templater plugin, you can create a template to quickly insert into any note:
# Backlinks
```dataview
list from [[{{tp_title}}]]
```
# Index
```dataview
list from outgoing([[{{tp_title}}]])
```
This might be very basic, but can I have the results published transcluded? So instead of the list produced being [[File_name]] it would be ![[File_name]].?
Not currently, no. If this isn’t already a feature request, I think it’s a great idea to post!
I’ve been looking all over for how to query around nested tags.
For instance, I may have a bunch of notes to aggregate Standard Work for my teams, but those will have nested tags. For a MOC page, I may want to create a list of all the Standard Work pages I have in my vault, inclusive of all of the nested tags. A way I would think I could write that is:
list from #standard-work/**
But I can’t find an ergonomic way of writing a query like this which doesn’t require me to where-clause against every known case of nested tag which is more static than I’d like. (I don’t want to update this page every time I add a new nested tag).
Any thoughts in the community?
Just to clarify, your questions says “I may want to create a list of all the Standard Work pages I have in my vault, inclusive of all of the nested tags”. So you want to list every page tagged with #standard-work
and also every page tagged with #standard-work/something/maybeMore
?
This snippet should do that:
list from #standard-work
Dataview already matches nested tags, so that list from #Tag
should match #Tag
as well as #Tag/sub
This ability to add the Backlinks and Index is awesome! Thanks.
Has anybody tried the GROUP BY
? I tried that but didn’t get the expected result.
For example, say I have some notes with the tags #Note/Author, #Note/Principle, #Note/Concept…how can I group all the results with tag #Note according to their subtags?
Could anyone help?
I actually hadn’t figured it out myself, but your question made me give it a go. I think I’ve got it…
So, I’m gonna use an example:
In each of my assignments, I have a field (intensity
) with a red, yellow, or green square telling me how much work will be required.
So, if I want to group all of my assignments by their intensity, I do the following.
First, gather all the assignments:
FROM #Assignments
Then, group by intensity
:
GROUP BY intensity
rows
Object
Now, here is the part that confused me… by grouping them, you’ve now got a new object created by the grouping. This is a nested list of all the assignments grouped by intensity. So something like:
[
[A1, A2, A6], // Green
[A3, A4], // Yellow
[A5, A7] // Red
]
The way you access this new list is with the rows
object.
So if I want the file name of every note in the array, I call rows.file.name
.
If I want the dueDate
of each note in the array, I call rows.dueDate
.
In this example, I call the title
property (rows.title
).
Now, you sorta have to change the ordering around, but it should still make sense.
TABLE intensity, rows.title
FROM #Assignment
GROUP BY intensity
Which gives me this, as desired:
So for your example, you want to group files by subtag. Can you try this and let me know what you get? I think the output will be a little messy, because it repeats alot of the tags, but it should still group them as you want.
TABLE rows.file.name, rows.file.tags
FROM #Note
GROUP BY file.tags
Also, it will only consider two notes to be in the same group if they have exactly the same tags. So even if two notes have #Note/Author
, if the one has a tag that the other doesn’t, I don’t think they’ll be grouped together.
wow @SkepticMystic Thank you so much for your elaborate and earnest answer! It does help a lot!
It is the rows Object that confused me too, and you’ve made it so clear. I tried replacing the rows.file.name with rows.file.link under your instruction, and now it works quite perfectly.
Just to let you know you helped me solve the long time problem.Thanks so much again!
Is there a way to show the number of result rows ?