Is it possible to use multiple SQL tables for the data displayed in the table?
Is it possible to use multiple SQL tables for the data displayed in the table?
mmcnair80
Posts: 83Questions: 21Answers: 7
I am working on creating a report builder that will allow users to select columns from multiple tables to be displayed in their report.
I'm wondering if there is a way that DataTables already has built in that would accomplish this?
I already have a way to get the table names and column names for the user selects. I can create a SQL query from that, but it won't be dynamic like using DataTables.
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
"I already have a way to get the table names and column names for the user selects. I can create a SQL query from that, but it won't be dynamic like using DataTables."
Why is it not dynamic if you have found a way to do this? I guess you would send the user selection to the server via ajax, execute your SQL and send the result back to the client. Sounds pretty dynamic to me! What am I not getting here?
@rf1234 You are correct. I figured it out. I have everything processing server side using a set of files called ServerSide.php and FilterSort.Class.php. I had to set up these to process the data correctly, which I had not done before posting this question. Now that I'm getting things setup it's mostly working. Still have a few bugs to work out.