CB Query Field has been upgraded to provide more than a simple query field to display the results of your database query. It now includes the following fieldtypes in addition to the existing Query fieldtype.
Query Checkbox (Multiple)
Query Dropdown (Single Select)
Query Dropdown (Multi-Select)
Query Radio Buttons
These new fieldtypes work exactly as the existing fieldtypes except their values are pulled from a database query (internal or external!). This means you can have a Select field, which pulls its values from your own database tables, 3rd party database tables, or any database for that matter.
These new fieldtypes fully support searching, translations, separate value and label per option (for example the value could be US and the label be United States), in addition to substitution within the query.
This adds to our ever growing list of new fieldtypes to further enhance your site! Please note these fieldtypes do not currently have Ajax capability, but CB Core Fields Ajax will be upgraded to support them.
Below is an example configuration to get you started (will work with all of the above types).
Query:
Code:
SELECT `id`, `username` FROM `#__users` LIMIT 20
Value Column: id
Label Column: username
For performance the new fieldtypes have built in caching of queries. This means if you have 10 fields that all use the query as exampled above then the query is only executed 1 time then cached.
Please do not use this topic for support. This is simply a news topic to discuss the release. If you have any support related issues then please post to your respective support forums, thank you.