[Asterisk-Users] Can I introduce sql sentences in the DialPlan (Asterisk Realtime)??

[Matthew Boehm]

Leonardo F. Bauchwitz wrote:
> Hallo all!
> 
> Know somebody, if exist Dialplan commands (specifically sql sentences)
> for Asterisk Realtime?
> 
> For example:
> I have users defined in mysql database.
> In the dialplan, I would like to select one field of a table.
> select email from sip_buddies where name=200
> 
> I try to use DBget, but I have error. I think because DBget use intern
> Database, and can 't connect to mysql.
> (Sintaxis:  DBget(varname=family/key))
> 
> I think (if it does not exist at the moment) that it is very interesant
> we can write in the dialplan sql-sentences
> What think about this?
> 
> Leonardo F. Bauchwitz

CLI> show application realtime

you could do

exten => 12,1,Realtime(sippeers,name,200)

also look at app_addon_mysql if you want to do pure SQL queries not 
supported by realtime

-Matthew