Hello,

I am not sure if this is a big, but it is something I noticed in my generated code (so possibly it could be due to the configuration I had set up in the generator).

Anyway, I noticed that in the JModel.item.php class there is no function generated to add a where clause to the generated query (like there is in JModel.list.php). Of course this was easy to fix, by adding the following code to jmodel.item.php:

I needed this to be able to filter data in some of the views.

Kind regards,

Misha

Hi blue-canoe,

This was the same in cook 1.5 builds

as you suggested the solution is drop the function addWhere($where_clause){...} into the JModel.item.php

Then you can display item views based on such things as user by using addWhere() without having to display a collection view first something like

it could be due to the configuration I had set up in the generator).

www.j-cook.pro/forum/9-coding-inside-you...specific-record#2793
NOT relevant to Cook V2.0 (The Model Sql structure has changed drastically since then)
but it gives you some idea of what you "might need to do" if your still working with 1.5 builds

Just Checked Cook V2.0
you dont need the addWhere() function in the jmodel.item.php
to limit data by multiple values
use something similar

Thanks! That is good to know.

Exactly.

AddWhere() is not available in item model. This is a choice to force you coding well.

Because ITEM is returning only one item, so you can never mix a filter on ID and something else.

in prepareQuery() :
- Create a new SQL context.
- Receive a customized state var.
- Filter on something else than ID, write your filter statement based on this received var.