Buy Now
Sign in

Dropdown with left join

rafaelscouto , November 27 2019, 19:57
R
rafaelscouto 176
November 27 2019, 19:57 #390151
With the settings in the image, I could not display the field "name" in the dropdown, in this case how should I proceed?

The "user_id" field is listed normally.

In the "uGer" model I make a left join with the joomla users table, because I need to get the username
0001.jpg
healyhatman 8
November 28 2019, 03:58 #390155
If you look at the debug, is it actually retrieving the name at all?
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
R
rafaelscouto 176
November 28 2019, 11:46 #390163
with the above setting (return an array of key / value pairs) I can only get the return from user_id (Ger.user_id), but if I change to (All matching records) I can get the return of names (uGer.name) too .
[read_managers] => Array
(
[log] => Array
(
[0] => SELECT `Ger`.`user_id` AS `Ger.user_id` FROM `e3nd_a_managers` AS `Ger` LIMIT 100;
)

[var] => Array
(
[930] => 930
[931] => 931
)

)
healyhatman 8
November 28 2019, 12:10 #390164
retrieve it as
Ger.userid:Ger.id
uGer.name:Ger.name
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
R
rafaelscouto 176
November 28 2019, 13:27 #390165
I was able to solve by changing the main db for users, and changing some options of the field (where conditions).