Block incoming calls from specific US states, other countries

[Marbled (Nicolas Riendeau)]

Hi!

Maybe something like what is discussed here could do it:

Inbound routing on CID problem

Yes, I’ve noticed that, but cid’s are really completely different, so impossible to find a good match wich doesn’t allow other cid’s too. Anyway, like I said, I already did them one by one, so for me the problem is solved. The question was more to have an answer on these scenario’s as it could come forward in future configurations. kind regards B

SmartRoutes Module Main Query

Hello Ladies and Gentleman, I am currently having some trouble with the “Queries” area of the module SmartRoutes that uses SQL/(MySql) “Queries” on an external (MySql) database. [size=20]I’m trying to have the route perform this little stunt.[/size] When the caller calls the DID number, I need SmartRoutes to query my external MySql CRM database for the table “companies” and search the column “company_phone1”. If it finds the matching 10 digit CID, it needs to now check the column “company…

If you are willing to type in all the area codes/prefixes needed it might even be able to address your other need (ie Caller enters zip code data to be routed, possible? - #2 by cynjut ) without having the user type in his zip code).

Good luck and have a nice day!

Nick