Datatables + Editor add where to query to load data

Datatables + Editor add where to query to load data

YoDavishYoDavish Posts: 123Questions: 46Answers: 3

Hello,

I'm currently using the Editor (JS + CSS version) with AutoFill and Key Table together. I need to update the query that loads the data to datatables to filter out a column that has been completed ("Completed <> 1") but I have no idea where to do this. Is this on the tableServer.php or the Database.php file or somewhere else? Thanks in advance.

Answers

  • YoDavishYoDavish Posts: 123Questions: 46Answers: 3

    Nvm I found the solution.

    I had to add it to the tableServer.php just above the
    ->Where ('column', 'value')
    ->process( $_POST)

This discussion has been closed.