<configuration name="cidlookup.conf" description="cidlookup Configuration">
<settings>
<param name="cache" value="true"/>
<param name="cache-expire" value="86400"/>
<param name="odbc-dsn" value="fusionpbx:fusionpbx:"/>
<param name="sql" value="
SELECT  p.contact_name_family ||', '|| p.contact_name_given as name
FROM v_contact_phones n INNER JOIN v_contacts p ON n.contact_uuid = p.contact_uuid
WHERE n.phone_number = '${caller_id_number}'
LIMIT 1
"/>
</settings>
</configuration>