Here the procedure to forward a call to an internal number (already existing):
...
CHECK: the value useful for the check of the next step. This value is extracted from the RESULT array: {RESULT[0][reference]}
3. Define the IVR structure
...
Trough the Database block you query the Database (you need to find if the INTERN variable corresponds to an already existing SIP reference) and you store the result of the query in the RESULT variable.
SELECT xcally.sip.reference FROM xcally.sip WHERE xcally.sip.reference='{INTERN}';
Through the Set CHECK block you extract the CHECK variable from the RESULT variable:
{RESULT[0][reference]}
Through the GotoIf and Goto blocks you can forward the call to the internal number typed by the caller (INTERN variable) if the GotoIf condition is valid:
...