I have 3 fields on a Demand form (see screen shot below). Need to get the total of the Capital and Operational Resource Duration fields to display in the "Total Estimated Project Duration" field. I am using the BR shown below (Total Estimated Project Duration) but it is not working. System Log shows that the BR is running.
From the screen shot below, the Total Capital Resource Duration and Total Operational Resource Duration get their values from 2 Business Rules that run on the Demand Table (See Related Lists below). Below the Related LIsts is the BR that runs on the Demand table to get the Operational Resource Duration …The Capital BR is configured exactly the same.
BR = Total Estimated Project Duration - Runs on Demand Table |
|---|
function onBefore(current, previous) { //This function gets total duration by adding the Capital and Operational Resource durations var timems = 0; var dur = 0; dur = current.u_tot_resource_duration_capital.getNumericValue(); timems += dur; dur = current.u_tot_resource_duration_operational.getNumericValue(); timems += dur; current.u_tot_est_project_duration.setDateNumericValue(timems); //gs.log("Did it work"); } |
| Related Lists on Demand table |
|---|
Related List — Capital Resources (u_dmn_resources_capital)
Related List - Operational Resources (u_dmn_resources_operational)
|
| BR = Total Operational Resource Duration - Runs on Demand table - Gets the sum of all Duration fields in Operational Resources Related List |
|---|
function onDisplay(current, g_scratchpad) { //This function queries the Related List records and adds the sum of durations to the Total Duration field on parent Demand var total=0; var grid = new GlideRecord('u_dmn_resources_operational'); //related list table name grid.addQuery('u_demand',current.getValue('sys_id')); grid.query(); while(grid.next()){ total+= grid.u_duration.dateNumericValue(); }
} |
