Async call causes identical code to execute fine in the console but not in a dataviewjs code block (solved)

[wealthychef1]

The problem

When I copy and paste code from my codeblock into the console (after setting dv appropriately), I get different behaviors with identical code.
Is this expected behavior, and if so why? I'm so close to getting what I want!

In my code block I get an error

p = dv.pages().where(file => file.meeting &&  file.meeting.type == "planning-tool").map(a => ['[[' + a.file.name + ']]', a.file.mtime])

var fileobj; 
var fs = require('fs');  

(await fs.stat('/Users/rcook/Library/Mobile Documents/iCloud~com~omnigroup~OmniGraffle/Documents/2021-2022 Timelines.graffle', (err, result) => { if (err) { console.log(err) } else { fileobj = result } } ))

p.values.push(['[2021-2022 Timelines.graffle](<file:///Users/rcook/Library/Mobile Documents/iCloud~com~omnigroup~OmniGraffle/Documents/2021-2022 Timelines.graffle>)', fileobj.mtime])

dv.table(["file", "mtime"], p)

The error

Evaluation Error: TypeError: Cannot read properties of undefined (reading 'mtime')
    at eval (eval at <anonymous> (plugin:dataview), <anonymous>:10:176)

In the Console I get a valid answer, no error

• Here's what happens when I copy and paste into the console. Spoiler alert: it just works fine.

dv = app.plugins.plugins.dataview.api // first set dv so we can use the same code
DataviewApi {app: e, index: FullIndex, settings: {…}, verNum: '0.5.47', value: {…}, …}
p = dv.pages().where(file => file.meeting &&  file.meeting.type == "planning-tool").map(a => ['[[' + a.file.name + ']]', a.file.mtime])

var fileobj; 
var fs = require('fs');  

(await fs.stat('/Users/rcook/Library/Mobile Documents/iCloud~com~omnigroup~OmniGraffle/Documents/2021-2022 Timelines.graffle', (err, result) => { if (err) { console.log(err) } else { fileobj = result } } ))

p.values.push(['[2021-2022 Timelines.graffle](<file:///Users/rcook/Library/Mobile Documents/iCloud~com~omnigroup~OmniGraffle/Documents/2021-2022 Timelines.graffle>)', fileobj.mtime])

6
p[5]
(2) ['[2021-2022 Timelines.graffle](<file:///Users/rcook…niGraffle/Documents/2021-2022 Timelines.graffle>)', Mon Nov 28 2022 22:45:17 GMT+0700 (Indochina Time)]

[AB1908]

Throw in a few console logs to see which mtime we're erroring out on.

[wealthychef1]

Hi, and thanks for taking the time.
The Console log has nothing in it. The error apparently gets funneled into a <pre> tag and inserted into the DOM.
But I can confirm it's the last line that's the problem, as the error goes away when I comment it out.
It is as if the fileobj in the codeblock does not get assigned properly or in the same way as in the console. Is it a scoping problem?

p = dv.pages().where(file => file.meeting &&  file.meeting.type == "planning-tool").map(a => ['[[' + a.file.name + ']]', a.file.mtime])

var fileobj; 
var fs = require('fs');  

(await fs.stat('/Users/rcook/Library/Mobile Documents/iCloud~com~omnigroup~OmniGraffle/Documents/2021-2022 Timelines.graffle', (err, result) => { if (err) { console.log(err) } else { fileobj = result } } ))

// p.values.push(['[2021-2022 Timelines.graffle](<file:///Users/rcook/Library/Mobile Documents/iCloud~com~omnigroup~OmniGraffle/Documents/2021-2022 Timelines.graffle>)', fileobj.mtime])

fileobj is undefined

[wealthychef1]

Solutions

Solution 1: put it in a handler

Found the problem: the await is async so fileobj is not set. Need to put all the things in the handler. Still have an issue formatting the date, but that seems solvable.
Is there a synchronous version of fs.stat() I could use? Hmm...

(await fs.stat('/Users/rcook/Library/Mobile Documents/iCloud~com~omnigroup~OmniGraffle/Documents/2021-2022 Timelines.graffle', (err, result) => { if (err) { console.log(err) } else { p.values.push(['[2021-2022 Timelines.graffle](<file:///Users/rcook/Library/Mobile Documents/iCloud~com~omnigroup~OmniGraffle/Documents/2021-2022 Timelines.graffle>)', result.mtime]); dv.table(['file', 'mtime'], p) } } ))

solution 2: use the synchronous version:

The synchronous versions of NodeJS are under fs.promises.xxx

p = dv.pages().where(file => file.meeting &&  file.meeting.type == "planning-tool").map(a => ['[[' + a.file.name + ']]', a.file.mtime])

var fileobj; 
var fs = require('fs');  
fileobj = await fs.promises.stat('/Users/rcook/Library/Mobile Documents/iCloud~com~omnigroup~OmniGraffle/Documents/2021-2022 Timelines.graffle')
p.values.push(['[2021-2022 Timelines.graffle](<file:///Users/rcook/Library/Mobile Documents/iCloud~com~omnigroup~OmniGraffle/Documents/2021-2022 Timelines.graffle>)', fileobj.mtime.toString()])
dv.table(['file', 'mtime'], p)

[AB1908]

Nicely done!