How to get only Messages where some specific custom field have value?

Does it work if you just query c_country like this? Do you get any response? 

SELECT * FROM c_country 

You should be able to query custom fields. If you are not, it may be a misconfiguration on the part of Khoros and they should check it again on a support ticket to see what's going on.