[Freeswitch-users] Passing Caller_ID to MOD_LCR

[Tchavdar Paskov]

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 at shaw.ca>
Date: Monday, February 16, 2009 10:44 pm
Subject: Re: [Freeswitch-users] Passing Caller_ID to MOD_LCR
To: freeswitch-users at 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 at lists.rupa.com>
> Date: Monday, February 16, 2009 9:01 pm
> Subject: Re: [Freeswitch-users] Passing Caller_ID to MOD_LCR
> To: freeswitch-users at 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 at lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > 
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> > 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20090216/20a911a0/attachment-0002.html