search

hermawanramadhan / CodeIgniter4-DataTables

MIT License
92 stars 38 forks source link

Manual Custom queries not working #18

Closed navnathsatav closed 1 year ago

navnathsatav commented 2 years ago

Does this support custom manual queries e.g. SELECT column1, column2... FROM table1 UNION SELECT column1, column2... FROM table2? Any solution for this?

erikkraijenoord commented 2 years ago

Depends on what driver you are working, with MySQL and i believe in MSSQL you have the VIEW option. This way the query is always done at SQL level, this makes it allot easier to get information from your table.

MySQL VIEW MSSQL VIEW PostgreSQL VIEW

These are just a few examples on how to approach the issues you are facing, good luck 👍