Showing 6 results.
Items per Page 50
of 1
First Previous Next Last

CVP Forum

« Back to Training Forum

Joins in sql statements

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Joins in sql statements
Answer
9/6/12 5:20 PM
I've been told that joins do not work in database elements in call studio. 
I was curious to see what would happen if you tried to use one, so i put one in a test script and tested it in the debugger and in live deployment, and I found no issues.
 
Does anyone know if join statements are now offically supported, or if they just happen to work now?
Or, have they always worked?
 
I'm running version 8.5.
Flag

Re: New Message from Asher Schweigart in Customer Voice Portal (CVP) - Trai
Answer
9/6/12 10:01 PM as a reply to Asher Schweigart.
Hi Asher, I've never heard that joins don't work when using the Studio
DB element. I think pretty much anything that works from a SQL command
window will work in the DB element. Do you remember where you heard that?

Janine
Flag

RE: New Message from Asher Schweigart in Customer Voice Portal (CVP) - Trai
Answer
9/6/12 10:16 PM as a reply to Asher Schweigart.
What has join got to do with Studio. It is just a function of SQL. Why will it not work ?
Hemal

From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
Sent: Thursday, September 06, 2012 11:21 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Asher Schweigart in Customer Voice Portal (CVP) - Training Forum: Joins in sql statements

Asher Schweigart has created a new message in the forum "Training Forum":

--------------------------------------------------------------
I've been told that joins do not work in database elements in call studio.
I was curious to see what would happen if you tried to use one, so i put one in a test script and tested it in the debugger and in live deployment, and I found no issues.

Does anyone know if join statements are now offically supported, or if they just happen to work now?
Or, have they always worked?

I'm running version 8.5.
--
To respond to this post, please click the following link:

<http://developer.cisco.com/web/cvp/forums/-/message_boards/view_message/6436270>

or simply reply to this email.
Flag

RE: New Message from Hemal Mehta in Customer Voice Portal (CVP) - Training
Answer
9/6/12 10:26 PM as a reply to Hemal Mehta.
I could have sworn that was talked about in class. Maybe I’m remembering wrong.
Flag