Enhancements
- The new auto ad hoc reviewer function now works with TEXT or calculated fields, rather than just LIST type fields. #afe #229993
-
Added new DocumentLinkSum functions to calculated fields that make it possible to add up values from linked documents.
#system
#230006
We’ve added four new formula functions to make it easy to pull text information from linked documents (in the case where there are multiple linked documents):
- DocumentLinkChildrenSum
- DocumentLinkChildrenSumFiltered
- DocumentLinkSum
- DocumentLinkSumFiltered
Each function returns the sum of a numeric field across linked documents.
i.e.
On a site, the following would return the sum of the Cost custom field on linked child wells.
DocumentLinkChildrenSum("WELL","CUSTOM/COST")While the following would add up the Cost custom field from linked “Maintenance” Jobs for the site.
DocumentLinkChildrenTextFirstFiltered("RTX","CUSTOM/COST","JOB_TYPE/VALUE","Maintenance")
Bugs
- Resolved issue where calculated fields would return the incorrect DOCUMENT_ID from linked child records. #system #230002
- Resolved issue where Execute would take HOURS to start up for customers with many AFE document links. #system #230443