How do you define context in realtime mySQL asterisk scenarios?

Asterisk Asterisk Support
1

Dear Asterisk Users, i want to make a dial plan such as when an extension is dialed suppose it’s (03111308308) then it checks the time if the time is regular office timing the IVR should say our office is open and the relevant menu should be played other wise it should say that the office is closed please record your message. i want to make to different context (open and closed). question is how do you define context in SQL? Any help will be much appreciated.

2
2.PNG900×403 75.5 KB

2

See the sample configuration file for example of time dependent context includes, or use GotoIfTIme ( https://wiki.asterisk.org/wiki/display/AST/Application_GotoIfTime ).

3

Thanks it is very helping . The question is how to write the context open and closed. like in the static real-time we do [open] and [closed] in the extensions.conf for defining the context. how do you do it in real-time dynamic mySQL.

4

Using the context column in the table!

1 Like
5

i see. thanks for the help. i am going to test it and share my results. thanks a lot