Skip to content

GitLab

Closed
Created by Josh Lamb@jlambOwner

Datatables total count and data queries break when using parameterized base query

When using a base query with a parameter, filtering breaks:

// Works because PDO is weird, would expect a parameter mismatch error
$base_query = 'SELECT * FROM trips';
$base_params = array('Test');

// Fails
$base_query = 'SELECT * FROM trips WHERE trip_type = ?';
$base_params = array('Test');

Bug fix - Need to use base_params when querying for the total count since datatables filters are not present in the count_total query but ARE present in params

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information