12-05-2011 02:20 AM - edited 03-14-2019 08:59 AM
I am trying to setup a sticky agent function i.e If the same client calls the CC within a time period then they'll get the same agent if he's availible
I have managed to do an external DB write and read but all the info i need is already on the servers informix DB
How do perform a read on my local informix DB from within the script ?
Thank
12-05-2011 04:53 AM
You can't officially. You can try creating a DSN that points at 127.0.0.1 but Informix isn't listed as a supported database in the compability matrix. You're better off to write a record to an external database once the agent takes the first call and then query it for each subsiquant call.
One word of caution: If you're using caller ID as your identifier don't forget that many businesses send out a generic/main number and not the individual DIDs.
12-05-2011 06:30 AM
Hey Jonathan
This is an internal Help Desk and whenthe caller call from theremobiles i have mobility enabled so i see it as an internal call also.
In your opnion what would be beter to write to a database or an xml document
Thanks
Lance
12-05-2011 09:07 AM
My preference for this would be SQL since it's faster to get working than all of the xpath and xsl transforms that would be needed.
One other option that is a bit more obscure: You can use a Java hash table stored into a session with a always-known mapping ID. This is probably the most ideal because:
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide