I'm a little confused by your code above.

echo("<pre>"); print_r($modelFoodbudgets); echo("</pre>"); // DBG temp VAR DUMP

echo("<pre>"); print_r($item); echo("</pre>"); // DBG temp VAR DUMP

dumps nothing - tried it in model and in fly page. Not sure if I'm doing something wrong.

should $item not be $this->item ???

In an item template:
In a list template :


Very important, you must respect the correct model side (front / back). Because it is separated.

Just to be 100% clear, then I'm working in frontend on an item

FRONT / BACK

definitivly.

EDIT : so you must write it in the front item model.

If you prefer to test your self, then please look in sandbox: sandbox.cms25.j-cook.pro/index.php?optio...et&layout=budget&cid[]=2

This is a budget item, where I'd like to display "sub budgets" that reference the budget item (food budget being one of them)

Ok, so do not touch the sandbox, I will exeptionaly write in it and show you.

You can play and prepare datas in it if you want, but DO NOT RUN in sandbox.

ok... I won't touch RUN now

I found.

If you are not in a form, it is missing something I will fix.


In the classes/jmodel.item.php :
function getItem() ;

after :
$this->populateParams($data);
add :
$this->populateObjects($data);

I try to show you in sandbox.
Try by your side as well.

Available in sandbox.

Fixed issue.
You can apply the patch I told you before, or upgrade classes/jmodel.item.php

I got to go now.

You know my PayPal, right ?

Have a good evening.
Happy to help you.

Got it working in my end as well
Thanks!!!!

Now I can get some sleep tonight

Received.

You are welcome.

I think Admin wins the prize! (Always willing to help us)

Hard life.

Next time, I will let you search a little bit and let you the prize !!

admin wrote: Well,

You cannot implement it in your SQL query. You must have another call.
The only way to do it in one query, is to create a groupby on a food budget list. but is is limited to these page only, so it is a wrong way if you want to be free.

I think for you, below is the correct answer :
(It works on an ITEM model for the moment)

in your model, models/budget.php :

1. Create a new function : (copy / paste this)

public function populateObjects(&$item)
{
	$modelFoodbudgets = JModel::getInstance('Foodbudgets', 'BudgetsModel');
	$modelFoodbudgets->addWhere('a.budget = ' . (int)$item->id);
	$item->foodbudget = $modelFoodbudgets->getItems();
}

2.Test it

3 lines. That's it !

Note : The amazing stuff is that populateObject function is available in infinite cascads !
I mean if you add such code in your foodbudgets model to obtain another N:1 links, you will get them also from budgets model.

It is really easy.

So, please consider also if you always need theses items everytime you load a budget.
This solution I propose you will ALWAYS load the foodbudgets items, even when you open a page that do not need it.

If you want to restrict the loading of the N:1 items, use the states vars :

In our example, let's define a state namespace : 'objects.budgets'

public function populateObjects(&$item)
{
	if ($this->getState('objects.budgets'))	//Custom namespace here
	{
		$modelFoodbudgets = JModel::getInstance('Foodbudgets', 'BudgetsModel');
		$modelFoodbudgets->addWhere('a.budget = ' . (int)$item->id);
		$item->foodbudget = $modelFoodbudgets->getItems();
	}
}

And this in your view file BEFORE to load the items :

$state->set('objects.budgets', true); //ADD THIS
$this->item = $item = $this->get('Item');	//loads the Items, do not touch

Is there an easy way to load only published items?

EDIT : If you are using Authoring functionalities, they will be handled