Call Studio DB Results to TTS

[John Ellis]

Forgive the basic question, but I am fairly new to CVP coding in studio.

I have an app that is prompting the caller for an extension and then a DB lookup after that to query for the agent name based off of the extension.  That part works great.

I need to validate the user, so I am trying to play TTS along the lines of "you are calling regarding {Data.Element.DBLookup.xml_resultset}" to play the actual name that was retrieved.

what actually plays is the full xml text, i get the TTS and the XML 1.yada yada yada... and then it plays the name and then the end of the XML string.

How do i get it to speak just the actual value, and not the whole string?

Thanks in advance,

John

[janinegraves]

The return value from the DB is stored into element data named with
whatever is returned from the DB.

Example, if the DB column was *agentName. *Then the *Query: select
agentName from mytable where ext=1234*

would be stored into element data named agentName and accessed as:
*{Data.Element.Database_01.**agentName**}*

Note that the variable DOES NOT display in the Substitution Window, you
just have to key it in.

[John Ellis · Accepted solution]

Thanks for the information!! 

So my select has me doing this at the start... SELECT concat(b.C_FNAME ,' ', b.C_LNAME) as FullName FROM ...

Then in the lookup, i am session a session data named "Name" to {Data.Element.IEX_DB_Lookup.FullName}

Do i need the asterisks?  Right now it is not playing the name at all. when i play {Data.Session.Name}

Or should I be playing {Data.Element.IEX_DB_Lookup.FullName} in the audio step?

Thanks,

J

[janinegraves]

You'll play the result from {Data.Element.IEX_DB_Lookup.FullName}

The asterisks were added by mistake by my email server, NO ASTERISKS

[John Ellis]

Thank you so much!  Wanted to be sure.  I may have to play with the db connection as it currently wont play anything.

I currently have the Type set to multiple and the Result-Set XML set to true.

Would those be the valid settings?