How use it with query conditions

[brunokimuramon]

my code:

public $components = array(
    'DataTable.DataTable' => array(
        'columns' => array(
            'Task.id' => array(
                'bSearchable' => 'plainSearch',
                'bSortable' => true
            ),                  
            'Task.inicio' => array(
                                    'bSearchable' => false,
                'bSortable' => true
            ),
            'Task.fim' => array(
                'bSearchable' => false,
                'bSortable' => true
            ),
            'Task.titulo' => array(
                'bSearchable' => 'plainSearch',
                'bSortable' => true
            )
        )
    )
);

public $helpers = array(
    'Js',
    'DataTable.DataTable'
);

public function index() {

    if ($this->request->is('ajax')) {

        $this->DataTable->paginate();

    }

}

I need put condition in my query, how can i do?

[tigrang]

$this->DataTable->settings['scope'] = array(); and $this->DataTable->settings['conditions'] = array();

[brunokimuramon]

Thanks, i used and it works:

        $this->DataTable->settings['Task'] = array(
            'conditions' => array(
                ...
            ),
        );

Now, i have associations defined in models and i want use "recursive = 1", how can i do it? Thanks again.

[tigrang]

Just set it after the conditions key.

[brunokimuramon]

Thanks! it works!

[tigrang]

No problem

[sherwinrobles]

I am trying to use condition based on if conditions.. but not working... no errors but the conditions is not working. what seems to be the problem? thanks.

//not working public function summary($biller_id = null) {

    if(!empty($biller_id)){
            $this->DataTable->settings['conditions'] = array('BillsTransaction.biller_id' => $biller_id);

    }

}

//working public function summary() {

            $this->DataTable->settings['conditions'] = array('BillsTransaction.biller_id' => 1);

}