I would like to use the SQL custom field to do any of the following:
pull in data with different datatypes (text, date, integer) from an external table
use a WHERE condition to filter
use JOIN in the query
I assume the query shoudl be posted in the Values box.
Any examples of the preferred syntax would be most welcome - not much to work with in the documentation...
Regards,
Alan