Grup dropdown list

Hello,

It is possible to display a list of users belong to a specific Joomla group (id=19) in a dropdown list?

I tried this code in CB Query Field but no field appear in profile:

Thank you

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.

CB Query Field can display the results of your query on profile (your query doesn't look correct), but it's not a functional field and is more like a delimiter field with its contents being your query result.

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.

Unfortunately, i already searched for info before posting this message and i couldn't find any helpful information.

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 )


P.S.: What do you mean by "your query doesn't look correct"? I used it in phpmyadmin and i can get desired results.

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 )

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).

P.S.: What do you mean by "your query doesn't look correct"? I used it in phpmyadmin and i can get desired results.

There's no escaping, you're using table prefix instead of #__, etc..

The above is escaped and replaced for proper Joomla/CB usage (e.g. in Query Field). Note this won't run in phpmyadmin because of #__, which is a feature in Joomla/CB to replace with the prefix automatically.