Hello,
from your documentation following SQL statement can be used to populate SQL Custom Field:
Code:
SELECT name AS value, name AS text FROM table WHERE published = 1 ORDER BY name
Is it possible to use variables in WHERE condition? Preferably USER ID or MEMBERSHIP ID? Something like this:
Code:
$user = JFactory::getUser();
$userId = $user->get('id');
SELECT name AS value, name AS text FROM table WHERE UserId = {$userId}
Thank you,
Martin
