Hi All,
I'm looking for a way to filter the AstDB cidname family to show only
those entries with a specified area code in the Asterisk CLI. If this
were a SQL database it would be something like:
SELECT number, name FROM cidname WHERE number LIKE '1234%'
I've tried database show cidname 1234* and
Geoff Lane wrote:
asterisk -rx database show cidname | grep area code
at the Linux shell prompt, but I'm looking for a way to do this
without leaving the Asterisk CLI.
I don't believe it does.
Doug
--
Ben Franklin quote:
Those who would give up Essential Liberty to purchase a little
On Mon, 2009-02-16 at 15:14 +, Geoff Lane wrote:
I'm looking for a way to filter the AstDB cidname family to show only
those entries with a specified area code in the Asterisk CLI.
I don't think this is possible with the current AstDB code.
If this
were a SQL database it would be
On Monday, February 16, 2009, Jared Smith wrote:
If you have that many items in a database and want to do those types
of filters, why not stick them in a SQL database and use func_odbc
to retrieve them from your SQL database inside the dialplan?
Thanks for your suggestion. My Asterisk machine
On Mon, 2009-02-16 at 16:30 +, Geoff Lane wrote:
Thanks for your suggestion. My Asterisk machine has MySQL, and I might
go down that route at some time. However, my query is part of an
almost academic exercise in which I'm trying to find out what AstDB is
capable of. Unfortunately your
On Monday, February 16, 2009, Jared Smith wrote:
Hopefully that helps make things a bit more clear.
It does - many thanks for your help.
--
Geoff
___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
asterisk-users mailing