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

Go to solution
Renu9
Tera Contributor

‎06-23-2022 04:15 AM

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

0 Helpfuls
  • 2,284 Views
1 ACCEPTED SOLUTION

Go to solution
Aman Kumar S
Kilo Patron
In response to Renu9

‎06-23-2022 04:30 AM

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.

View solution in original post

0 Helpfuls
5 REPLIES 5

Go to solution
Not applicable
In response to suvro

‎12-29-2022 01:45 PM

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?
0 Helpfuls