fork through mysql

[iKenny]

I have a stored procedure for routing witch return a single column named 'location'
In section of call route in register.conf i have a query for procedure and result option
query=call routing('${caller}', '${called}')
result=location

The thing i would like to do is to make a call to a user and if he didn't answered after
a while - redirect call to another number. User number is 111 for example and number for redirection is 222
I am bit confused, in that case, what should my procedure return?
I suppose it must return a location with
"fork route/111 |exec=15000 route/222"?
Or maybe something else?
Thank you for answer.

[iKenny]

I have found the solution.
The key is first to call to client's location, then to call to second number.
In short, location must be

Code: [Select]

fork sip/sip:user number@ip |exec=5000 route/number to redirect |stoperror=busy
for procedure in it self you can contact me via e-mail

[vankooch]

Have look at: http://docs.yate.ro/wiki/Call_Forker