trying to do a keyword search on note text after .where query

[erazlogo]

I need to search the entire note text after narrowing down by folder and one or more search fields. I understand that Dataview is not designed for that, but this is what I need to do.

@AB1908 suggested this route on Discord: https://discord.com/channels/686053708261228577/875721010144477204/983783814604140625

const pages = dv.pages('"01 notes"')
	.where(p => p.title && p.title.includes("Cuba"))
	.mutate(p => p.content = await dv.io.load(path))
	.filter(p => p.content.includes("Water"));
    
dv.table(
        ["Note", "Title"],
            pages.map( p => [
                p.file.link,
                p.title
            ])
    );

This query works fine without .mutate/filter but with these two actions I get the error below. Any help would be appreciated. Thank you!

Evaluation Error: SyntaxError: missing ) after argument list
    at DataviewInlineApi.eval (plugin:dataview:19514:21)
    at evalInContext (plugin:dataview:19515:7)
    at asyncEvalInContext (plugin:dataview:19522:16)
    at DataviewJSRenderer.render (plugin:dataview:19546:19)
    at DataviewJSRenderer.onload (plugin:dataview:19153:14)
    at DataviewJSRenderer.t.load (app://obsidian.md/app.js:1:677361)
    at e.t.addChild (app://obsidian.md/app.js:1:677785)
    at e.addChild (app://obsidian.md/app.js:1:1613266)
    at Object.addChild (app://obsidian.md/app.js:1:1612291)
    at DataviewApi.executeJs (plugin:dataview:19908:19)

[AB1908]

A few things:

• path needs to be p.path
• It says there's a missing closing paren but I actually don't see anything wrong. Could you try matching them up?

[erazlogo]

I changed to p.path and I am still getting the same error. VS Code sees no problems with the () -- they all match. Puzzling.

[erazlogo]

Ok so this works! If this could be simplified, I'd be glad to know how.

const pages = await Promise.all(
    dv.pages('"01 notes"')
    .where(p => p.title && p.title.includes("Cuba"))
    .map(page => new Promise(async (resolve, reject) => {
        const content = await dv.io.load(page.file.path);
        resolve({
            link: page.file.link,
            title: page.title,
            content
        });
    }))
);

dv.table(
        ["Note", "Title"],
            pages
            .filter(p => p.content && p.content.includes("Water"))
            .map( p => [
                p.link,
                p.title
            ])
    );

[AB1908]

I'd never have expected that you'd have to create a new Promise here. TIL.