Book Image

Elastix Unified Communications Server Cookbook

Book Image

Elastix Unified Communications Server Cookbook

Overview of this book

Table of Contents (24 chapters)
Elastix Unified Communications Server Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Description and Use of the Most Well-known FreePBX Modules
Addon Market Module
Asterisk Essential Commands
Asterisk Gateway Interface Programming
Helpful Linux Commands
Index

Using MySQL to search for the caller's name


This option allows us to search for the caller's name in a database.

How to do it…

If we wanted to use a MySQL query to search for the caller name for an incoming caller ID, we must enter the Host, the Database, the Username, the Password, and the Query that will be executed to search for the name. Cache results options are checked in the image. This will allow the system to store results astDB in the cache, so that the system can perform lookups locally instead of remote lookups. This is shown in the next image:

The database query would be as follows: select name from users with an extension like %[NUMBER]%. This will search in the database for the name of the caller associated with the number in the table called users.