Dynamic Realm Rules

ClearBox can select a realm for request processing using a SQL command. The common use case for it is when some realm condition involves checking large amount of data, such as a wholesale provider selecting realms by a dialed number stored in a database.

Select Dynamic Realm Rules under Realms:

Use SQL command to query for realm IDs. Use this option to turn on dynamic realm selection.

Data source. Select a configured data connection from the list which will execute the command.

SQL command. Type in the command here which selects exactly one row with one string field denoting a realm ID. If no rows are selected, ClearBox uses common static realm rules.

A command may include special keys ($u, $c, $n, $s) and any request attributes (read more).

Sample command: SELECT top 1 'RealmID1' where '{Called-Station-Id}' in (select Number from DNIS)

Click Apply Changes after any changes to these settings.