How to update calling list fields for all record of the same chain_id?

[alaint]

Our agents use Interaction Workspace.  For one of our calling list, we have some User-Defined Field that are editable.  When agent change the value of these User-Defined Field, we want that all record for the same chain_id was affect by these changes.

Is there a by design way to do that?  If not, how can I do that?  I was thinking about making some vb.net code on a ...beforeClose custom command.  But I have difficulty on how to talk to OCS.  I already use SDK to talk with UCS, but never with OCS.  If someone can help me with code sample, it will be perfect.

We are with Genesys 8.1.

Alain

[Kubig]

If you have configured OCS with saving immediately result, you can do this within database (for example through trigger). I am using custom database operation within OCS solution very often.

[alaint]

I'm not sure, but I think it is not possible to update another row of the same table in an update trigger?

[cavagnaro]

Use an after trigger pulling the original chain_id

[alaint]

always have this error : ORA-04091: table is mutating, trigger

[Steve]

ORA-04091: table is mutating - Means that the trigger is either changing the data that fires the trigger (an endless loop) or trying to change some data that is currently being modified by the statement that fired the trigger.

It sounds like the latter in this case, the agent changes one record in a chain and then the trigger tries to change the whole chain.
You might be able to get round it by using :NEW and :OLD in the trigger, or by excluding the record that the agent is changing.

[alaint]

Take a look at the trigger I've try.  What am I doing wrong?

CREATE or REPLACE TRIGGER testAlain
AFTER UPDATE ON clist_dgag_qc_wdi_test_telem
FOR EACH ROW

BEGIN

  if updating ('field_dgag_commentaires') then
        update clist_dgag_qc_wdi_test_telem
        set field_dgag_commentaires = :new.field_dgag_commentaires
        where chain_id = :new.chain_id
        and chain_n <> :new.chain_n
        and field_dgag_commentaires <> :new.field_dgag_commentaires;
  end if;
   
END;

[alaint]

Finally, I have succed to update all records of a same chain ID, by IWS customization.

[code]
For Each record As Genesyslab.Enterprise.Model.Interaction.IRecord In interaction.OutboundChainRecord.Records
          record.CustomFields.Item("commentaires") = "commentaire"
          _outboundService.UpdateRecord(_agent.FirstMediaVoice.Device, record, Nothing, Nothing)
Next
[/code]

alaint