I also have another question. When i insert my custom query it looks like the profile is loaded successfully but then when i place a call or use lcr ########## default /which is where i defined the sql query/ and check the console output turns out that the switch is using the default sql guery . How i can make sure that the custom sql is the only one that is to be executed. /All required fields in the custom sql are in accordance with the requirements - it returns the exact required names and returned field number is also correct/. Thank you agai for your time Chav ----- Original Message ----- From: Tchavdar Paskov <chavpaskov@shaw.ca> Date: Monday, February 16, 2009 10:44 pm Subject: Re: [Freeswitch-users] Passing Caller_ID to MOD_LCR To: freeswitch-users@lists.freeswitch.org
i was thinking more in direction of building custom sql that deals with both Caller_id and destination number. I'm aware that the current off the box mod_lcr has no such ability and that's why i asked if there is a way from dial plan to pass the caller_id_number channel variable to mod_lcr. Thanks
----- Original Message ----- From: "Rupa Schomaker (lists)" <freeswitch-users@lists.rupa.com> Date: Monday, February 16, 2009 9:01 pm Subject: Re: [Freeswitch-users] Passing Caller_ID to MOD_LCR To: freeswitch-users@lists.freeswitch.org
On 2/16/2009 7:40 PM, Tchavdar Paskov wrote:
Hi, Is there a way to pass Caller Id to mod lcr and somehow to include it in a custom sql. currently my dialplan looks like this:
<extension name="LCR"> <condition field="destination_number" expression="^1(\d+)$" break="never"> <action application="set" data="bypass_media=true" /> <action application="lcr" data="$1"/> <action application="bridge" data="${lcr_auto_route}"/> </condition> </extension> i guess that Caller_ID is already passed but i was thinking about making some LCR decisions based on Destination number and Caller_ID> > /Interstate,Intrastate for example/
Thanks for your time
mod_lcr doesn't make any decisions based on caller id. Probably the best way to handle this would be to use profiles. You could extract the areacode and use that to determine which profile to use. It would be awkward if you want to handle all area codes -- but for a smaller set of area codes it might be sufficient.
Regards Chav
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users