search

IgnitedDatatables / Ignited-Datatables

Ignited Datatables is a wrapper class/library based on the native Datatables server-side implementation by Allan Jardine found at http://datatables.net/examples/data_sources/server_side.html for CodeIgniter
285 stars 335 forks source link

Ignited Datatables selecting all columns even when column names are specified #141

Open uday-bacancy opened 3 years ago

uday-bacancy commented 3 years ago

Actual code :

$this->datatables->select('e.id,e.from_number,cg.name,e.customer_id, e.employee_id, e.vendor_id, e.mobile,

raw query print

SELECT * FROM sms_subscribe_history as e LEFT JOIN customer as c ON c.customer_id = e.customer_id LEFT JOIN employee as emp ON emp.employee_id = e.employee_id LEFT JOIN vendor as v ON v.id = e.vendor_id LEFT JOIN customer_group as cg ON cg.id = e.group_id WHERE e.merchant_id = '' AND DATE(e.created_at) BETWEEN '2021-06-28' AND '2021-06-29'

issue is i mention all fields but when i print query it's show me *

AchuthanU commented 2 years ago

That is because the get_total_results() function call.