Query help; How to make a list of outgoing links from the notes within this field:: --- use case; to summarise important outlinks in this week's Daily Notes.

[DryIce1]

Hi @AB1908,

I am reopening the discord discussion we had been attempting to have over a few weekends here, as you requested.

The goal is to have in my Weekly Note a list of outlinks mentioned from each daily note. This will be a prompt to recall which of the notes from this week were most intereating.

Desired Outcome / details

• working from a weekly note which has the field, days:: and contains links to the 7 daily notes for this week, like this; - **Days**:: [[2022-04-18]], [[2022-04-19]], [[2022-04-20]], [[2022-04-21]], [[2022-04-22]], [[2022-04-23]], [[2022-04-24]]
• I would like a list of outlinks from each of the daily notes within the field days
• And finally, to exclude any outlinks that contain the tag #📓 (because each of my periodic notes contains this tag)

---

Your attempt on discord:

```dataviewjs
const excludeThis = "file/path";
dv.list(
  dv.current()
    .days
    .map(t=>dv.page(t.path))
    .filter(t=>!t.file.tags.includes("#📓"))
    .filter(t=>t.file.path! = excludeThis)
)

• this gives me an error
• If I remove the two filters, I get the file metadata the outlinks in the field days, and this is the correct target.
• However, your code suggestion doesn't quite get me to the days.outlinks and I wasn't able to find a solution.

---

mnvwvnm had an attempt with an inline query which almost worked:
$=dv.list(dv.page(dv.current().days).file.outlinks.where(o => !dv.page(o.path).file.tags.includes("#📓")))

• It works only if days contains only one link.
• But because days is autopopulated with links to the seven days of the week, it bounces an error "Error: dv.page only handles string and link paths; was provided type 'object'"

---

thanks in advance for any advice or solutions! 🙏

[AB1908]

	```dataviewjs
	dv.table(
	    ["File", "Outlinks"],
	    dv.current()
		.days
		.map(t=>dv.page(t.path))
		.filter(t=>t)
		.filter(t=>!t.file.tags.includes("#📓"))
		.filter(t=>t.file.path != excludeThis)
		.map(t=>[t.file.link, t.file.outlinks])
	)
	```

should do the trick.

[DryIce1]

Thanks @AB1908, this is awesome and teaches me a lot!

It does the job, however, the tag exclusion criteria isn't quite focused on the right target as it is more nuanced than I may have explained above.

Specifically, each of my daily notes contains the outlinks in fields yesterday:: and this-week:: . So is it possible to modify the t.file.outlinks, so that it doesn't list a link that matches a criteria? ie so that it doesn't list the two outlinks in yesterday and week?

thanks @AB1908

[DryIce1]

Is it possible to use Regex Replace on the resulting list from the file outlinks?

[AB1908]

There have been quite a few changes, did any of them help you or is this still an issue?

[DryIce1]

Hi @AB1908 , I got the result I wanted with the recent updates to lists and sections.

The first query is in my weekly note, and lists outlinks contained under the section "Journal" from the daily notes related to this weekly note. Super quick (instantaneous) to load because the from criteria only matches the 7 related daily notes.

These are in my top ten dataview queries of all time :)

Journal

Outlinks

TABLE without id
	link(date, dateformat(date.file.day, "ccc d MMM")) as Date,
	rows.Lists.outlinks as Outlinks
FROM [[<% tp.file.title %>]] and #log/daily 
FLATTEN file.lists AS Lists
WHERE file.day >= date(this.days[0]) 
WHERE file.day <= date(this.days[6])
WHERE meta(Lists.section).subpath = "Journal"
WHERE Lists.outlinks
GROUP BY file.link as date
SORT file.day asc

Journal summary

TABLE without id
	link(date, dateformat(date.file.day, "ccc d MMM")) as date,
	rows.Lists.text as Journal
FROM [[<% tp.file.title %>]] and #log/daily 
FLATTEN file.lists AS Lists
WHERE file.day >= date(this.days[0]) 
WHERE file.day <= date(this.days[6])
WHERE meta(Lists.section).subpath = "Journal"
GROUP BY file.link as date 
SORT file.day asc

[AB1908]

Put this in a separate answer and give yourself some credit! 😄

[DryIce1]

TABLE WITHOUT ID 
	link(date, dateformat(date.file.day, "ccc d MMM")) as Date,
	rows.Lists.outlinks as Outlinks
FROM [[<% tp.file.title %>]] and #log/daily 
FLATTEN file.lists AS Lists
WHERE file.day >= date(this.days[0]) 
WHERE file.day <= date(this.days[6])
WHERE meta(Lists.section).subpath = "Journal"
WHERE Lists.outlinks
GROUP BY file.link as date
SORT file.day asc