need understanding on Interaction Server DB

[Dimitry]

Hi All,

I would like to understand on the IXN DB . I have an incoming XML which I would store into IXN DB for IWD purpose which will then be presented to agent.  IXN DB has specific core attribute and they exist as a separate column in the DB.  Now I want to have some additional data stored as flexible properties .. How should I do that ? Will the flexible properties be stored as BLOB ? if so do I need to do some conversion before storing it into the DB ?

[cavagnaro]

The xml could be an Interaction attribute. Therefore, create a custom column and map it to a KVP (UserData) following standard IXN documentation. With this you attach the xml value. However, there are size restrictions in the UserData size. Why not just send the xml link where it is generated from and then on agent IWS/WDE you load it? That would make more sense.

Enviado de meu E6633 usando Tapatalk

[Dimitry]

Thanks Cavagnaro

The reason is if we have custom properties created each will have a different column created.. For example .. I have <employeeID>AAAA</employeeID>  tag , if I create a custom attribute then I have specify a column employeeID (varchar2) in the DB.
Instead if I store it in a BLOB we could keep adding many tags to BLOB ..  Hope I am correct...  And when the work item is presented , I could pass it as attached data to WDE.

Please correct me if I am wrong