How to access the value defined in the key of target files?

[wenlzhang]

I have two files/notes that are defined as follows:

[[Project action A]]

#ToDoDataview 

- Completed:: 
- Project:: [[Project A]]
- Status:: Active

- Due Date:: 2022-01-12

[[Project A]]

#ProjectDataview 

- Completed:: 
- Action:: 
- Status:: Active

I then use the following query to access the status of the [[Project A]] that is linked to [[Project action A]]. However, I got - as the Project Status, while the desired value is Active.

let pages = dv.pages('#ToDoDataview and -"Templates"');

for (let group of pages
	.where(p => p["status"] == "Active")
	.groupBy(p => p["status"])
	.sort(group => group.key, 'asc')) {
		dv.header(4, group.key);
		dv.table(["Name", "Due", "Project Status"],
			group.rows
				.sort(k => k["priority"])
				.map(k => [dv.func.link(k.file.path, k.file.name), k["due-date"], k.project.status]))
}

I also tried to check the keys of [[Project A]] that can be accessed with two methods.

• However, the first one gives 0 as the result.
• The second one is a little better, and it gives the following results: path, type, subpath, display and embed. However, it does not give the keys that are defined explicitly, i.e. Completed, Action and Status.

let pages = dv.pages('#ToDoDataview and -"Templates"');

for (let group of pages
	.where(p => p["status"] == "Active")
	.groupBy(p => p["status"])
	.sort(group => group.key, 'asc')) {
		dv.header(4, group.key);
		dv.table(["Name", "Due", "Project Status"],
			group.rows
				.sort(k => k["priority"])
				.map(k => [dv.func.link(k.file.path, k.file.name), k["due-date"], Object.keys([[k.project]])]))
}

let pages = dv.pages('#ToDoDataview and -"Templates"');

for (let group of pages
	.where(p => p["status"] == "Active")
	.groupBy(p => p["status"])
	.sort(group => group.key, 'asc')) {
		dv.header(4, group.key);
		dv.table(["Name", "Due", "Project Status"],
			group.rows
				.sort(k => k["priority"])
				.map(k => [dv.func.link(k.file.path, k.file.name), k["due-date"], Object.keys(k.project)]))
}

[blacksmithgu]

DataviewJS doesn't currently allow directly indexing "through" links (it's possibly but a little tricky); you use dv.page() to resolve links instead. So to get your project status, use

dv.page(k.project).status.

[wenlzhang]

Thanks for the help! It works for me now!