Hi,
I am trying to link 3 tables together using the DB Multi Record Loader, but I can not get it to work. I am following the tutorial here: http://chronoengine.com/faqs/view/2649/how-can-i-link-two-db-multi-record-loaders.html
For a current logged in user, I would like to display a list of bags he has previously registered. That list will then pull model info from a different table. The three tables are #__users, #__registrations, and #__productinfo.
I am able to get it so that it displays the current user's registered bags (located on #__registrations). However, I am unable to connect to #__productinfo and show what models those bags are.
Here is my setup for the On Load event:
DB Record Loader to load the current user (this works)
Show html
DBMRL1
DBMRL2
Now, here is how the DB Record Loader, and two DBMRL's are set up:
DBRL
DB Field: id
Table: #__users
Where:
<?php
$user = &JFactory::getUser();
echo "id = ".$user->id ;
$form->data['uid'] = $user->id;
?>
DBMRL1
Table: #__productinfo
Model ID: Baginfo
Load Data: No
Enable Associations: No
JOIN type: LEFT
JOIN rule: Userbags.prodno = Baginfo.productnum
DBMRL2
DB Field: uid
Table: #__registrations
Request Param: Users.id
Model ID: Userbags
Load Data: Yes
Enable Associations: Yes
JOIN Type: Left
Associated Models: Users, Baginfo
Enable Data Displayer: yes
Display Fields: registerdate, prodno, Baginfo.model
Other info: #__registrations has a field called prodno which I am trying to join to a field called productnum. productnum is on #__productinfo.
When it is output, Baginfo.model doesn't show up.
Am I doing the JOINs correctly?
I am trying to link 3 tables together using the DB Multi Record Loader, but I can not get it to work. I am following the tutorial here: http://chronoengine.com/faqs/view/2649/how-can-i-link-two-db-multi-record-loaders.html
For a current logged in user, I would like to display a list of bags he has previously registered. That list will then pull model info from a different table. The three tables are #__users, #__registrations, and #__productinfo.
I am able to get it so that it displays the current user's registered bags (located on #__registrations). However, I am unable to connect to #__productinfo and show what models those bags are.
Here is my setup for the On Load event:
DB Record Loader to load the current user (this works)
Show html
DBMRL1
DBMRL2
Now, here is how the DB Record Loader, and two DBMRL's are set up:
DBRL
DB Field: id
Table: #__users
Where:
<?php
$user = &JFactory::getUser();
echo "id = ".$user->id ;
$form->data['uid'] = $user->id;
?>
DBMRL1
Table: #__productinfo
Model ID: Baginfo
Load Data: No
Enable Associations: No
JOIN type: LEFT
JOIN rule: Userbags.prodno = Baginfo.productnum
DBMRL2
DB Field: uid
Table: #__registrations
Request Param: Users.id
Model ID: Userbags
Load Data: Yes
Enable Associations: Yes
JOIN Type: Left
Associated Models: Users, Baginfo
Enable Data Displayer: yes
Display Fields: registerdate, prodno, Baginfo.model
Other info: #__registrations has a field called prodno which I am trying to join to a field called productnum. productnum is on #__productinfo.
When it is output, Baginfo.model doesn't show up.
Am I doing the JOINs correctly?
Hello,
If you are trying to do this in order to list the tables data then please contact me through the "Contact us" page to get the new Connectivity which does this stuff like this easily.
Regards,
Max
If you are trying to do this in order to list the tables data then please contact me through the "Contact us" page to get the new Connectivity which does this stuff like this easily.
Regards,
Max
This topic is locked and no more replies can be posted.