[pimnr47]

Hi all,

 

I am so thankful for Grocery crud, it has sped up my development incredibly!

 

I would like to use the where clause. I tried using the parameter at the end of the url of my route, but that messes up the ajax call query and returns a 500:

 

   public function listsales($transactionId = null){

 

        $crud = new grocery_CRUD();

 

        $crud->set_theme('flexigrid');

        $crud->set_table('sale');

        

        $transactionId = $this->input->get('saletransactionId', TRUE);

        if(isset($transactionId)){

            $crud->where('saletransactionId', $transactionId);

        }

 

 

   //more grocery stuff...

   }

 

This works fine with datatables. Anyway, now I try it with a get parameter, like so:

 

   public function listsales(){

 

        $crud = new grocery_CRUD();

 

        $crud->set_theme('flexigrid');

        $crud->set_table('sale');

        

        $transactionId = $this->input->get('saletransactionId', TRUE);

        if(isset($transactionId)){

            $crud->where('saletransactionId', $transactionId);

        }

 

 

   //more grocery stuff...

   }

 

 

This works, but after a second, flexigrid reloads the table contents with an ajax call and ignores the where clause completely.

 

Any way to include the where clause in the async calls? Or prevent the first async call after page load would also work for me.

 

Thank you!

 

Cheers,

Pim