DataSet CSS example sheet is incorrect

[Dan Garner]

Stylesheet for the Table

Currently the following code is used.
td#col_1 {

}

But it should be as follow.
td#column_1 {

}

[Dan Garner (dangarner)]

datasetview.module.php line#452

[Dan Garner (dangarner)]

It would also be nice to extend the filtering options so that better subsets of data could be returned:

Example:

Example filter for Mondays Lunch menu: “WeekDay=Monday,Menu=Lunch”. But technically you could have only 2 designs, one for breakfast and lunch. You could use the following filter: “WeekDay=DayName(Now()),Menu=Lunch”. Of course the proper quotation has to be done by the user.

$filterPair = explode('=', $filterPair);

//Current code

//$where .= sprintf(" AND %s = '%s' ", $filterPair[0], $db->escape_string($filterPair[1]));

//Possible change

$where .= sprintf(" AND %s = %s ", $filterPair[0], $filterPair[1]);

[Barry Wood (barry-x8)]

Dan,
When might this fix be implemented in Xibo? I ask as this change will make a massive difference to me using datasets. At the moment I find the functionality too limiting, but with the ability to filter data with normal SQL syntax it would make everything much easier to manage.

[Dan Garner (dangarner)]

It is implemented in the attached branch (150) and will be released when 1.5.0 is ready - there is no set date for this yet, but I would imagine a few months maximum.