Skip to content

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

@uday-bacancy

Description

@uday-bacancy

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 *

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions