[larasmith]

I tried the sample in using the API: setModal from https://www.grocerycrud.com/enterprise/api-and-function-list/setModel

and here is the content of my custom model:

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

use GroceryCrud\Core\Model;

class m_Signatories extends Model {

    protected $ci;
    protected $db;

    function __construct($databaseConfig) {
        $this->setDatabaseConnection($databaseConfig);

        $this->ci = & get_instance();
        $this->db = $this->ci->db;
    }

    public function extraWhereStatements($select)
    { 
        $select->where('sig.sig_UId = '.$_SESSION['uid'].' or sig.sig_IsShared = 1');
        return $select;
    }
   
}
?>

The where condition was successfully implemented but the filtering or searching is now broken. Refer to the image below:
 

 

Kindly check on this issue @web-johnny 

 

Thanks!

[web-johnny]

Hello @larasmith,

 

Can you try the query but with a parenthesis? For example:
 

$select->where('(sig.sig_UId = '.$_SESSION['uid'].' OR sig.sig_IsShared = 1)');

Please let me know if that worked for you.

 

Regards

Johnny

[larasmith]

Hello @web-johnny!

 

It did work! :lol: Thank you very much for the support! :lol:

I have other posts too aside from this one I hope you can provide support there too!

Thanks again!

 

Regards,

Lara