WD.NOTES
Description
Returns rows associated with an advanced report which previously contained a Live Data Note but are no longer displayed in the current report output.
This function is useful for scenarios where customers have used Live Data Notes on a report, and later:
- The report fails to load or refresh, or
- Prompt values or prompt configuration change and certain rows are no longer displayed, or
- The underlying data changes and previously displayed rows no longer appear in the output.
The function returns an array with the columns
User
, Date
, Key column name
, and Note column name
. The array's data rows show the Notes that have not been placed back into the Live Data area when the area was refreshed.Syntax
WD.NOTES(
address
)- address: The anchor cell of the Live Data.