select a.name from jos_users a left join jos_user_usergroup_map b on a.id = b.user_id where a.block=0 and b.group_id = 19 order by a.name
Please Log in to join the conversation.
Please Log in to join the conversation.
krileon wrote: Not with anything we provide. I think there's a plugin that lets you build a dropdown list from a query, but I don't recall what it's called; please search.
Please Log in to join the conversation.
I've no plans to make such a plugin, but it should be doable when CB 2.0 comes out (hoping for beta by end of year).There is any plan of making this kind of plugin in near future? Something "light", a database join which retrieve id for value and name for text and display info in a dropdown list (Fabrik style )
There's no escaping, you're using table prefix instead of #__, etc..P.S.: What do you mean by "your query doesn't look correct"? I used it in phpmyadmin and i can get desired results.
SELECT a.`name`
FROM `#__users` AS a
LEFT JOIN `#__user_usergroup_map` AS b
ON a.`id` = b.`user_id`
WHERE a.`block` = 0
AND b.`group_id` = 19
ORDER BY a.`name`
Please Log in to join the conversation.