mike asked 11 years ago
Hello, right now I have a gird that is bound to a table like so
$g->table = "[pltdata].[dbo].[Web_BoneyardTable]";
Now I have been asked to filter the grid so only certain "grades" of material show. Grade is one of my table fields. I assume I need to follow the convention below, but not sure how I would do it. I will need to show multiple grades so I think it would be grade = 'value1' ot grade = 'value2' etc…
//$g->select_command = "select * from (select * from invheader) as o";
// pass the cooked columns to grid
Abu Ghufran answered 11 years ago
Hello,
Yes, it should work with select_command.
e.g.
$g->select_command = "select * [pltdata].[dbo].[Web_BoneyardTable] where grade = 'value1' ot grade = 'value2'";
mike answered 11 years ago
Now i get this
$g->select_command = "select * [pltdata].[dbo].[Web_BoneyardTable] where grade = 'value1' ot grade = 'value2'";
Looking through the forum as well
