[Bug]: Query.data Returns Undefined After Awaiting Query Run in an JS Function That Runs on Page Load

[ame-appsmith]

Is there an existing issue for this?

• I have searched the existing issues

Description

The user runs a query, then stores the data returned to Appsmith store. The code snippet used is similar to the below one:

await Query1.run();
await storeValue('myData', Query1.data[0], false);

However, the code does not run as expected and the value stored to Appsmith store is undefined, although the await keyword was used; hence, the query should have run before the result was stored to Appsmith store.
This behavior is only present if the code is run on page load. If it is run manually, it always returns the expected result.

The workaround is to assign the query run to a variable and store this variable to Appsmith store by using the following snippet instead, which is safer:

let myQueryData = await Query1.run();
await storeValue('myData', myQueryData[0], false);

However, the first approach should have worked too, since the await keyword was used correctly.

Steps To Reproduce

Ticket with screenshots of the original code

Public Sample App

No response

Environment

Production

Severity

Medium (Frustrating UX)

Issue video log

No response

Version

Self Hosted