UCCX DB Get Multiple Rows

[jbushong2]

I am connecting to a database and retrieving over 27,000 rows. I get (DB Get) the data from the first row and am able to manipulate as needed however, when I send the script back to the DB Get step, it retrieves the first row of data again. It never looks at other rows.

DB Read : resource: getCayenta, database: Cayenta
Successful -Get Data:
DB Get : resource :getCayenta
Sucessful - [check variables in debug]
go to Get Data

[Elliot Dierksen]

Are you sure you aren't going back to the DB Read step? That would restart the query from the beginning which sounds like what you are experiencing. You execute the DB Read once, and then the DB Get repetitively until you get a No Data result.