Skip to main content
David Kemp ha fatto una domanda in #Data Management
Hi,

 

We currently have a series of checkboxes on Service Contract that are checked/unchecked to show what "features" are associated with the

 

Service Contract, i.e. which products are included

 

So for example, we might have Service Contract 1 that has features A,B and C where A,B and C are Contract Line Items, when they are in

 

date and are therefore Active, we want the appropriate checkbox on the Service Contract to be checked.

 

This is all working fine except for when items that were created with future dates i.e. Inactive cross the date boundary and become Active.

 

We would like the trigger to fire for this occurrence so that we can update the checkbox, but it does not.

 

Is there a way to force the trigger to fire?  I can't find a way of telling when the Status changes as this does not seem to create any events.

 

Any ideas gratefully received.

 

Regards,

 

David
2 risposte
  1. 31 mar 2014, 13:06
    As far as i got you question , this can be a possible solution for this:{considering you have contract as master and child contract line items}

     

    1. You need to write a trigger on the contract line item with event After Update.

     

    2.In your trigger get the id of the master (contract)

     

    3. update the status on the master(contract).
0/9000