Due date on sc_Task to be populated to due date on RITM

Renu9 · ‎06-23-2022

Hi All,

I am trying to populate due date on sc_task and also on ritm based on a variable (effective date) in one of my catalog item.

So, when effective date is filled, the same date has to populate on sc_task and ritm

I have written a BR on sc_Tasktable before insert

var effdt=current.request_item.variables.effective_date;
if(effdt != '')
{
current.due_date = effdt;
}

This is making sc_Task due date to set, from here how can I set the RITM due date with effective date.

Please suggest

Aman Kumar S · ‎06-23-2022

Yes, you can but if it is following the same flow, I think it will be a better idea to keep it in workflow/flow than in BR.

From performance as well as maintainability point of view, if you are building a solution for a specific requirement which caters to particular set of tasks, BR is not a good idea at table level.

Just think from this perspective, your RITM and sctask table grows by a lot over time and this BR will run every time there is a insert and at least has to go through condition checking, whereas in your workflow dedicated for these catalog items, will only be specific for records for these catalog items.

Best Regards
Aman Kumar

View solution in original post

Suzanne Coffman · ‎12-29-2022

I have the same question. I added

current.due_date = current.variables.projected_prod_release_date;

to scripting for the due date field in my Update Requested Item Record step in the flow, and I added task.due_date = current.variables.effective_date;

to scripting on the due date field of the Create Catalog Task. Both of these were after the Get Catalog Variables step that I have confirmed is grabbing the date that I am adding in the previous task. But the due date is not being updated on either the RITM or the second task. What am I missing?