Table / List from specific bullet point list

[josephcrawfordSRH]

In my daily journals I have a bullet point list like the following

### Code Reviews
 * <link>
 * <link>
 * <link>
 
 ### Meetings
 * <link>
 * <link>
 * <link>

In my weekly template I would like to have a table/list displayed nicely that would show all code reviews completed that week, is there a way to isolate the code review list from other lists in my document?

[holroy]

You're not giving a whole lot of information related to the naming of your daily notes, and how you intend to pull out the daily notes related to the current week, so I'm assuming you know how to do that.

If you then in your query do something like FLATTEN file.lists as item, you can then do something like WHERE meta(item.section) = "Code Reviews" to pick out only list items from that section.

[josephcrawfordSRH]

@holroy thanks for the response, sorry for my delay I have been sick for the last 4 days. I have attempted to do what you have suggested and there are a few questions I have.

1. Is there a way to do this without using a TABLE and having column headers? I would like this to look how tasks do where there is a header and then just a list of completed tasks. This is what I have for my tasks query.

TASK
FROM "Journal/Daily"
WHERE completed
AND file.day.year = number(substring(string(this.file.name), 0, 4))
AND file.day.weekyear = number(substring(string(this.file.name), 6, 8))
SORT file.day

I guess I should provide a bit of a back story on what I currently have and what I am trying to accomplish, sorry that I did not originally do that.

In my daily template I have the something like the following

## Code Reviews
  * http://github.com/path/to/review
  * http://github.com/path/to/review
  * http://github.com/path/to/review

In my Weekly template I would like to have the exact same thing but rather than it being something I type into the template for my entry I would like for it to query all daily files for that week and generate the list of code reviews completed that week.

I have tried the following, but I receive the following error Dataview: Unrecognized query operation 'folder'. I am guessing because this wants me to specify the "Journal/Daily" next to LIST vs in a FROM, but then I am not sure how I would do the FLATTEN bit.

LIST FLATTEN file.lists as item
FROM "Journal/Daily"
WHERE file.day.year = number(substring(string(this.file.name), 0, 4))
AND file.day.weekyear = number(substring(string(this.file.name), 6, 8))
AND meta(item.section) = "Code Reviews"

SORT file.day

Not to convolute this with another question but I was thinking about my monthly/annual templates may just provide a count of code reviews completed. Is there a way to not only get all links for the weekly and then in my monthly get a count of how many bullet points were under code review?

My apologies if I am not clear on something I am still getting the hang of Obsidian and templates.

[holroy]

You're close, but the FLATTEN needs to be after the FROM statement, so try the following:

```dataview 
LIST item.text
FROM "Journal/Daily"
WHERE file.day.year = number(substring(string(this.file.name), 0, 4))
AND file.day.weekyear = number(substring(string(this.file.name), 6, 8))
SORT file.day
FLATTEN file.lists as item
WHERE meta(item.section) = "Code Reviews"
```

---

Regarding the other request on counting, you'd need to do something similar, and then add a GROUP BY statement. But start out by seeing if you're able to query all the links you want to count. Maybe something like:

```dataview
LIST length(rows)
FROM "Journal/Daily"
WHERE file.day
FLATTEN dateformat(file.day, "YYYY-MM") as fileMonth
FLATTEN file.lists as item
WHERE meta(item.section) = "Code Reviews"
GROUP BY fileMonth
```

If I didn't make any stupid mistakes that query should go through all of your dailies, extracting only list items under the "Code Reviews" heading, and then group them by the month, and count how many there were in each month.

[josephcrawfordSRH]

@holroy First I want to thank you for your time on this, I truly appreciate it and if I am not providing any details you may need to better assist me please do let me know.

Interestingly enough I just generated my weekly note based on the query above for the Code Reviews and nothing was returned for data. I am not quite sure why as I have other queries using this format just fine, at-first I thought my substring indexes may have been off but then I checked my Completed Tasks Query.

Completed Tasks

TASK
FROM "Journal/Daily"
WHERE completed
AND file.day.year = number(substring(string(this.file.name), 0, 4))
AND file.day.weekyear = number(substring(string(this.file.name), 6, 8))
SORT file.day

When I do it for the Code Reviews, I even tried Meetings it just returns no data in the view.

Just so you can see, this is what the contents are in my Weekly Template
NOTE: I did remove the ticks (`) before dataview and after the query so that it could be formatted here.

## Incomplete Tasks
dataview
TASK
FROM "Journal/Daily"
WHERE !completed
AND file.day.year <= number(substring(string(this.file.name), 0, 4))
AND file.day.weekyear <= number(substring(string(this.file.name), 6, 8))
SORT file.day

---

## Completed Tasks
dataview
TASK
FROM "Journal/Daily"
WHERE completed
AND file.day.year = number(substring(string(this.file.name), 0, 4))
AND file.day.weekyear = number(substring(string(this.file.name), 6, 8))
SORT file.day

---

## Completed Code Reviews

dataview 
LIST item.text
FROM "Journal/Daily"
WHERE file.day.year = number(substring(string(this.file.name), 0, 4))
AND file.day.weekyear = number(substring(string(this.file.name), 6, 8))
SORT file.day
FLATTEN file.lists as item
WHERE meta(item.section) = "Code Reviews"

---
## Meetings

dataview 
LIST item.text
FROM "Journal/Daily"
WHERE file.day.year = number(substring(string(this.file.name), 0, 4))
AND file.day.weekyear = number(substring(string(this.file.name), 6, 8))
SORT file.day
FLATTEN file.lists as item
WHERE meta(item.section) = "Meetings"
---

This is what the data looks like in one of my daily notes

## Tasks 
- [ ] A task goes here
- [ ] Another task

## Code Reviews
* https://github.com/path/to/pull/request
* https://github.com/path/to/pull/request

## Meetings
* I met with Jerimiah to discuss another meeting
* I met with Jonathan to go over the task PROJ-2344 

## Things that slowed me down
* I was sick most of the week

This is what is put into my weekly note when generated
I have shown the source for Code Reviews but the only difference in the queries for these is the strings "Code Reviews" and "Meetings", both return the same result when not viewing the source.

[holroy]

My bad, I was a little quick on the trigger there, and forgot to do meta(...).subpath, so try this variant:

```dataview
LIST item.text
FROM "Journal/Daily"
WHERE file.day.year = number(substring(string(this.file.name), 0, 4))
AND file.day.weekyear = number(substring(string(this.file.name), 6, 8))
SORT file.day
FLATTEN file.lists as item
WHERE meta(item.section).subpath = "Code Reviews"
```

Bonus tip: How to present code properly in a post

If you want to showcase either markdown, or code blocks, or dataview queries properly in a post, be sure to add one line before and one life after what you want to present with four backticks, ````. This will ensure that any other backticks (like in code blocks or queries) is properly shown.

[josephcrawfordSRH]

@holroy awesome that works and shows that I need to cleanup my templates to remove empty bullet points lol

I appreciate you showing how that worked.

As for that bonus tip I much appreciate that I had tried it as I believe I saw someone mention that but I failed to do the newlines and could not get it to work

[josephcrawfordSRH]

@holroy I know this area is for the data-view plugin but I have a question you may be able to answer.

Can you tell me what I need to research or where I can ask such a question to find the answer?

In my monthly template I would love to be able to do something like this.

This month I completed 50 code reviews and attended 37 meetings.  I was able to complete 90 tasks
and have 10 tasks that were incomplete.

I know I can do the counting and grouping like you stated above but that outputs in a data-view table like this

## Completed Code Reviews
 * YYYY-03: 50

If you are aware of any way to do this please direct me to the appropriate place to find my answers.

I have tried managed to get this to work but man it is a bit complex in the result structure lol.

```dataviewjs 
const result = await dv.query('LIST length(rows) FROM "Journal/Daily" WHERE file.day FLATTEN dateformat(file.day, "YYYY-MM") as fileMonth FLATTEN file.lists as item WHERE meta(item.section).subpath = "Code Reviews" GROUP BY fileMonth');

dv.paragraph('<br>I have completed  **' + result.value.values[0].value + '** code reviews this week!'); 
```

I am however unable to get the same thing to work for weekly using YYYY-WW in the dateformat call in the query. The counts are off by a lot so I must be doing something wrong there and am probably only getting lucky that the monthly counts line up.

```dataviewjs 
const result = await dv.query('LIST length(rows) FROM "Journal/Daily" WHERE file.day FLATTEN dateformat(file.day, "YYYY-WW") as fileWeek FLATTEN file.lists as item WHERE meta(item.section).subpath = "Code Reviews" GROUP BY fileWeek');

dv.paragraph('<br>I have completed  **' + result.value.values[0].value + '** code reviews this week!'); 
```