DB Multi Record Loaders issue

eldywan 24 Apr, 2013
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?
Max_admin 01 May, 2013
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
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.