[cisco-voip] 2 rows DB query for UCCX

[shary shary]

1- its version is 7.0.1 with Sr4.
2- Infact this table can have more than more rows agains one field. Infact what i need to know first how many row returns after query to DB and if it has more than 1 row then get the data of all rows and save them in to an array and to access all of them one by one.
 
Reagrds
sheeraz
 


Date: Thu, 11 Nov 2010 09:03:33 -0600
Subject: Re: [cisco-voip] 2 rows DB query for UCCX
From: avholloway+cisco-voip at gmail.com
To: shaary1 at hotmail.com
CC: cisco-voip at puck.nether.net

1. I have an idea about this, but not sure if it's available in 7.0(1) (you are on 7.0(1) correct? which SR?).
2. You cannot get the number of rows returned from the DB Read Step.  Under the success branch, create a loop, using a label and a goto step, that executes the DB Get step until it lands in the No Data branch.  Keep track of your loop count to know how many records were returned.


Anthony


On Thu, Nov 11, 2010 at 12:16 AM, shary shary <shaary1 at hotmail.com> wrote:


hi folks,
I have 2 queries regardin the UCCX 7.0.2. 
 
1- My customer wants to catch the Call Release Event performed by the Agent on CAD and put it into any report. So i want to ask how would i catch this event and put it in customize report.
 
2- During DB fetching i got 2 rows against the one field and my ask is to chcek if DB is returing 2 rows against one field then it should ask for some more information otherwise go directly to agent. How can i check this option in a "Success option" of DB Read Node.
 
 

Regards,
Sheeraz Saeed lodhi.




_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip


 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20101113/0d03388c/attachment.html>