CB Query field

Hi,
I need text field contain membership status from AEC database.

I tried following steps,

Step 1

Type = Query
Name = cb_Status
Title = Status

Query = SELECT `status` FROM `#__acctexp_subscr` WHERE `userid` = '[user_id]'
Query Mode = Internal

Results Output = Single Row
Results Columns = Single Column

Location Registration = Disabled
Location Profile Edit = Disabled
Location Profile View = Enabled
Location Userlists View = Enabled

Step 1 Result
Field not available on backend and frontend profile view

I need to set the result as default value inside cb_status field.
Any idea what i'm missing...


Step 2

Type = Query Drop Down (Single Select)
Name = cb_Status1
Title = Status1

Query = SELECT `status` FROM `#__acctexp_subscr` WHERE `userid` = '[user_id]'
Query Mode = Internal

Options Value Column = user_id
Options Label Column = Membership Status
Options Group Column = blank

Step 2 Result
Its success and The field is visible with correct data inside dropdownlist

I need to set the result as selected value inside cb_statu1 field instead drop down list.

Thanks in Advance

The standard query field just queries the database and outputs the result of the query. It doesn't do anything beyond that. If your query is going to result in multiple rows then be sure you limit it to 1 result with LIMIT 1 unless using a multiple row display.

Test your raw query on phpmyadmin for expected results. Also check if you're conditioning your query field with CB Conditional or disabling its output with CB Privacy. What kind of value are you expecting it to output? String? Integer? Date?

Hi,
The option2 it works fine.
The result populate from database and the drop down list shows the fields

e.g.

result1
result2
result3

But i need one of this field as selected by default on drop down list.
Im trying to save additional field to cb from another database.

Best Regards,
Firdous

But i need one of this field as selected by default on drop down list.

You need to use the "Default Registration Value" parameter when editing your field to have a default value pre-selected. Note this only works at registration. The alternative is to adjust the ORDER BY of your query and try to force the value you want pre-selected to be the first value of the field.

Im trying to save additional field to cb from another database.

Then you may want to use CB Auto Actions and just keep the two databases in sync. CB Query Field just outputs the results of the query. It does not save anything. The query select field of course saves, but only if the user registers with something selected or updates their profile with something selected as the query select fields are just populating a select with options.