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 <chavpas...@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-us...@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 > > http://www.freeswitch.org > > >
_______________________________________________ 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 http://www.freeswitch.org