If any can ..a little help :

I want populate a tx field of CB from other field inside same database

(create a field query for each text field like populate ex ZIP )


i use this query

SELECT `value` FROM `ogkjt_jblance_custom_field_value` WHERE `fieldid` = '9'

work ..but this populate the same value for all user, i like any user have the appropriate value

better explain here the query i need :

The X Field of all User (like ZIP and is different from user to user) ) registered with Joombri

populate the X Field of all Same User with same value in Community Builder for each user

With a query posted , yes populate the field but is the same field for all user example

User A populate with zip 111111
User B populate with zip 111111
User C populate with zip 111111

i want the realy value for each user like

User A populate with zip 111111
User B populate with zip 222222
User C populate with zip 333333


any suggestion for complete code at this query to import value from user

Thankyou+

Also found this on post forum ..but no work (also ext. is the same)

SELECT category
FROM sgj_jblance_user, sgj_jblance_category, sgj_users
WHERE sgj_jblance_category.id=sgj_jblance_user.id_category AND '[user_id]'=sgj_jblance_user.user_id

found this query (from a forum post) i have tested on my site and work (display exact value for each user) :

SELECT category
FROM sgj_jblance_user, sgj_jblance_category, sgj_users
WHERE sgj_jblance_category.id=sgj_jblance_user.id_category AND '[user_id]'=sgj_jblance_user.user_id


I'm not able replicate this query for a my single field custom at Joombri eaxmple
Have in joombri the customer JOLIE with fields called zip is 1111
i want a db query for insert in Community builder the zip 1111 for the user JOLIE in Community builder.
(note i have the customer JOLIE in Jombri and also in CB )

Krileon can help with this?

Attach you table-database (db is a same of CB) joombri with a field like query/field/import

thank you+