Hi All,
I need to use partial matches on the CIDNAME family I have stored in
AstDB. For example, an organisation might have several numbers with
the same area code and the same first few digits:
1234 567890
1234 567889
1234 567824
...
I'd like to store these (e.g.) as CIDNAME/12345678* (where "*" is
a
wildcard) so that I can retrieve the organisation name from
extensions.conf with:
Set(CALLERID(name)=${DB(cidname/${CALLERID(num)})})
Does AstDB support this (I'm using Asterisk 1.4.22.1)?
I know that I can create a function to iterate backwards through the
number until a partial match is met, but I'd rather use built-in
functionality should it exist.
TIA,
--
Geoff
Hi, On 12:09, Wed 27 May 09, Geoff Lane wrote:> Hi All, > > I need to use partial matches on the CIDNAME family I have stored in > AstDB. For example, an organisation might have several numbers with > the same area code and the same first few digits: > > 1234 567890 > 1234 567889 > 1234 567824 > ... > > I'd like to store these (e.g.) as CIDNAME/12345678* (where "*" is a > wildcard) so that I can retrieve the organisation name from > extensions.conf with: > Set(CALLERID(name)=${DB(cidname/${CALLERID(num)})}) > > Does AstDB support this (I'm using Asterisk 1.4.22.1)?Nope.> > I know that I can create a function to iterate backwards through the > number until a partial match is met, but I'd rather use built-in > functionality should it exist.It's your only option. -- Michiel van Baak michiel at vanbaak.eu http://michiel.vanbaak.eu GnuPG key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x71C946BD "Why is it drug addicts and computer aficionados are both called users?"
Maybe splitting key-value like this would help ? database put Prefix1234 56789 database put Prefix1234 56788 database put Prefix1222 56789 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090527/7574c3c6/attachment.htm