You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 *
The text was updated successfully, but these errors were encountered:
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
ase
LEFT JOINcustomer
asc
ONc
.customer_id
=e
.customer_id
LEFT JOINemployee
asemp
ONemp
.employee_id
=e
.employee_id
LEFT JOINvendor
asv
ONv
.id
=e
.vendor_id
LEFT JOINcustomer_group
ascg
ONcg
.id
=e
.group_id
WHEREe
.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 *
The text was updated successfully, but these errors were encountered: