DataviewJS query that filters where a value from the Project array matches the file name of the file containing the query

[GRIT-Nic]

Hello all!

I'm trying to modify a DataviewJS query to include only the #note files that refer to the file containing the query.

In my example, I have one file for each Project, and then each note contains an array, which I use Metadata Menu to populate the Project property with one or more projects depending on what's discussed in a given meeting.

Currently, that query looks like this:

const {fieldModifier: f} =
	  this.app.plugins.plugins["metadata-menu"].api;

dv.table(['File', 'Subject', 'Date', 'Project', 'Hours', 'Submitted'],
	dv.pages('#note AND "Notes"')
        .sort(p => p.Date, "desc)
	.map(p => [
		p.file.link,
		f(dv, p, "Subject"),
                f(dv, p, "Date"),
		f(dv, p, "Project"),
		f(dv, p, "Hours"),
		f(dv, p, "Submitted to OA")
	])
)

There's actually three versions of these query that I'm hoping to produce.

"Dashboard View"

For the first version of this query, I want to limit these entries to the past 10 days.

"Project View"

For the second version, I want to limit the entries to just the ones where the file hosting the query is referenced as a value in the Project array.

"Submitted View"

Lastly, I want to filter the view for entries where "Submitted to OA" is NOT TRUE

If anyone is able to help me set these up, I'd greatly appreciate the help. I've tried searching all over for all three of these and I'm falling flat.

[GRIT-Nic]

Turns out this was answered a long time ago in this comment: #961 (comment)