[#3619] CB Query Field Translation

Thanks, have installed it but without success in translation. I went up to test the simplest query form my gender field which is from Drop Down (Single Select) type, properly translated, whose values are strings:
_UE_MALE
_UE_FEMALE

and the stupid test query is:
SELECT `cb_gender`
FROM `jos_comprofiler`
WHERE `user_id` = '[user_id]'

OK return the right sex but displays _UE_MALE, which is present (to achieve the test)in both language.php and cbteamplugins_language.php

Am I missing something?

Try translating the string in cbteamsplugins with the below.

'_UE_MALE' => 'Male'

The old defines usage is just that, old, I don't implement support for it anymore; nor test its usage. The result is passed through substitutions where I've set it to translate these strings, but maybe there's a space or something preventing the translation.

Just confirmed translation worked fine (new and old). Where are you using the field at specifically? How is the field configured? Single row? Maybe CB language plugins aren't loaded yet. Try editing cbqueryfield.php and adding cbimport( 'language.cbteamplugins' ); to the top of getQuery function and confirm if working.

Thanks, as said, had the translations OK (in both styles in case of), language.cbteamplugins was already loaded, but had the Multiple columns activated. So configuring back to Single column... Works fine, don't need to add cbimport( 'language.cbteamplugins' ); to the top of getQuery function.

Have tested the following query and as far as you live Rows and Columns to Single, translation works (for sure, in that case it's only displaying the 1st field)
SELECT `cb_gender`,`cb_country`
FROM `jos_comprofiler`
WHERE `user_id` = '[user_id]'

Seems that multiples rows or columns give problems even adding cbimport( 'language.cbteamplugins' ); to the top of getQuery function. .

Now with these 2 translations systems in parallel, I have to duplicate some strings for each language (eg. 250 country names) x number of languages of the site...you imagine the work.

Please provide your exact configuration that's not working. When using multiple columns it uses a header/row/footer type display, which you supply substitutions for columns to (e.g. [column_cb_gender]) and it translates the entire header/row/footer so translations may not work as the expected result will be different.

Field Title: _UE_COUNTRYNAME, in translation field DEFINE('_UE_COUNTRYNAME','Test País-Sexo');

SELECT `cb_country`, `cb_gender`
FROM `jos_comprofiler`
WHERE `user_id` = '[user_id]'

Mode Internal
Output Single Row
Columns Multiple Columns
Display Delimiter
Delimiter Space

Result:
Test País-Sexo: Switzerland _UE_MALE

But both `cb_country` and `cb_gender` will be well translated if kept alone with Single Row and Single Column