cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

Joins in sql statements

9
Views
0
Helpful
0
Comments
This document was generated from CDN thread

Created by: Asher Schweigart on 06-09-2012 12:20:36 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.

Subject: Re: New Message from Asher Schweigart in Customer Voice Portal (CVP) - Trai
Replied by: Janine Graves on 06-09-2012 05:01:45 PM
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

Subject: RE: New Message from Asher Schweigart in Customer Voice Portal (CVP) - Trai
Replied by: Hemal Mehta on 06-09-2012 05:16:46 PM
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.

Subject: RE: New Message from Hemal Mehta in Customer Voice Portal (CVP) - Training
Replied by: Asher Schweigart on 06-09-2012 05:26:13 PM
I could have sworn that was talked about in class. Maybe I’m remembering wrong.
CreatePlease to create content
Content for Community-Ad
FusionCharts will render here