We need a way to show a value instead of a key when EDIT is required
Given you don't support an INNER JOIN, and apparently, when using a view, one can't use edit, we need a way to show a value instead of a key on grids that you want to use for edits. For instance, when listing an Orders table, you want to show the Customer's name, not their ID.
3
votes
ta4118
shared this idea
-
martijn
commented
Yes Enas, I've managed to get that working as well, only then the grid is non-editable... The set_col_edittype works while remaining the functionality to edit.
-
AdminRichard
(Admin, phpGrid)
commented
Please use "select" edit type. See http://phpgrid.com/documentation/set_col_edittype/
-
Enas
commented
$sdg = new C_DataGrid("SELECT `t1`.ticket_id AS `ticket_id`, `t2`.quantity,
FROM `Tickets` AS `t1` JOIN `Order` AS `t2` ON `t1`.ticket_id = `t2`.ticket_id", "ticket_id", $sdg_table_name);This has worked for me so far .