Xibo

  1. Bug #1133043
  2. Comment #2

Comment 2 for bug 1133043

Revision history for this message
Dan Garner (dangarner) wrote :

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]);