CB Query field: Display information from a table.

I added a query field to the profile page.
The query is: SELECT `field1`,`field1` FROM `mytable` where 'ID'=[userid]

Only the field ttle is displayed. I tried multiple permutations of the syntax, but I could not find any information of the CB query field to construct the query.

Your substitution isn't valid and it's missing quotes so if there's no result your query will error. Your select is selecting multiple columns instead of a single column so unless you've configured it for multiple column display your results may not be as expected. Please see the below example query structure.


I recommend searching the forums for additional usages, our tutorials below, and Nicks videos below.

Tutorials: www.joomlapolis.com/support/tutorials
Videos: www.youtube.com/playlist?list=PLp0puRITgC7MM9iP9FooKB1qk8f5MLWVp

I got the query to work and see the (single value) list in the user profile. How can I get a list with radio buttons to choose one for further action?

You'd need to use a Query Radio fieldtype. Please see the below that examples how to make a country field using Query Select fieldtype. It's basically the same concept except different fieldtype.

www.joomlapolis.com/support/tutorials/107-use-cases/18377-configuring-a-country-field-with-cb-query-field-plugin

Sample works. Thank you. Is there a way to show the selection dialog on the profile page when you are not in edit mode? That's what I was looking for, but I may have to write custom HTML for it, which I try to avoid.

You'll need to install CB Core Fields Ajax and make the field ajax editable.