Asterisk bridge

Hi all…sorry to bore you…but i have a problem and i don’t find nor the solution neither the path to follow…

Scenario…1 call from outside…put on hold it…

Retrieve 10 numbers from mysql db…dial each number one at a time…ask for:“press 1 to accept, press 2 to deny”
On 1 bridge call with that on hold
On 2 follow the next number…

I have developed already ODBC part but didn’t find how to call and pass variable in sequence…
I saw that with new channel i lost variables i collect via odbc…

Thanks a lot

You could pump data from ODBC (longer term storage) with func_odbc.conf edits, then save to local Asterisk internal DB, for use of that info in other call paths. See DB Functions. Just try to un-set them when you are done in the other path.

Or you might benefit from use of Local channels to re-enter the dialplan. Something like this could be modified to preserve key information between call 1 and calls 2-11:

exten => s,n(muhcooldial),Dial(Local/12345*67890@some-other-context)