...
- Objects that only have simple formula fields will always have coherent data stored in the local database
- Objects that have cross-record formula fields will accumulate stale data in those formula fields , because Pulsar does not recalculate formulas for all records that might be affected when a particular other record is updatedby a change
- NOTE that stale data is not necessarily problematic for many organizations. The problems generally arise in the following scenarios:
- Showing cross-record formulas in list views
- Direct querying of cross-record formula fields in the database from custom code (e.g. SQL querying via PSL or via the Pulsar Javascript API).
...