[SOLVED] How to access the SELECT clause's SUM() value from the WHERE clause with Codeigniter active record

How to access the SELECT clause's SUM() value from the WHERE clause with Codeigniter active record

I have following activerecord code to get invoice and sum of its payment.

$this->db->select('invoice.*,customer.custid,customer.cust_name,customer.cperson,customer.cust_email,customer.cust_mobile,customer.cust_address,sum(payment_received.amount) as paid_amount');
$this->db->join('customer','customer.custid=invoice.custid');
$this->db->join('payment_received','invoice.inid=payment_received.inid','left');
$this->db->where('@paid_amount IS NULL');

Because of codeigniter escape column name with '`' this char its showing error "Unknown column '@paid_amount' in 'where clause'"

How to stop escaping of column name ??

Solution

Have you looked at the User Guide? Both the get and where methods accept a parameter to prevent CI from escaping the data.

https://ellislab.com/codeIgniter/user-guide/database/active_record.html