To run a given script only once and cache and return the output value
This function allows you to cache calculations of an elaborate script during the first execution. Instead of a new calculation, the saved value is then returned.
But if you want to trigger a recalculation of your script, you have the following options:
- Activate the edit mode
- Execute the
invalidate()function in any table of your database
This feature can help solve performance problems.
let cache := cached(
let user := user();
select Tasks where 'Due Date' > today() and 'Assigned user'.'Ninox user' = user
Result: The records from the Tasks table that are still open and assigned to the current user are cached and returned.