v 1.3.3 grocery CRUD - an automatic Codeigniter CRUD

[eluser]timj[/eluser]
Hello, I've asked this question of the developer by email and the answer I received made no sense to me, so I am sending it to a wider list in the hopes someone can explain this to me.

I want to build a few callbacks that build a query thus: 'SELECT from database WHERE client_id = $uri->segment(3)';

If I do this:

Code:

$crud->set_table('orders');
$crud->where('client_id = 1');

I get a list of records in the orders table that are related only to client_id 1, so I know this product can work. This is exactly what I want, except with '1' as a variable. When I offer a variable, this product tells me it doesn't know what to do with the data.

I was offered this as a possible solution:

Code:

function manage_orders($state = 'list', $id)
{
    if( ($state == 'list' || $state == 'ajax_list') )
    {
        $session = $this->session->userdata("client_id");
        if(!empty($id))
        {
            $this->session->set_userdata(array("client_id" => $id));
        }
        elseif(empty($id) && !empty($session))
        {
            $id = $session;
        }
        if(!empty($id))
            $this->grocery_crud->where('client_id',$id);
        }
...
}

However, this "solution" throws a lot of errors and doesn't produce a variable this product can understand:

Fatal error: Uncaught exception 'Exception' with message 'The state is unknown , I don't know what I will do with your data!' in /home/public_html/application/third_party/grocery_crud/libraries/grocery_crud.php:2398 Stack trace: #0 /home/public_html/application/controllers/test.php(105): grocery_CRUD->render() #1 /home/public_html/system/core/CodeIgniter.php(339): Test->manage_orders('2') #2 /home/public_html/index.php(201): require_once('/home/...') #3 {main} thrown in /home/public_html/application/third_party/grocery_crud/libraries/grocery_crud.php on line 2398

It seems to me the thing I want to do is what EVERY PERSON who uses this product at any length would ultimately want to do, quickly build nested CRUD tables.

If someone can help me I'd appreciate it. And I would suggest that this simple functionality be built in as an option in future releases.