Sunil asked 11 years ago
My Grid is populated using dropdowns, when I export it using excel it is putting only keys of select not the values.
Id Client ID Avatar Status Project Process
466374 4 395 20 3 66
All the above numbers expect ID are suppose to show respective name and not their ID's.
Please Help
1 Answers
Abu Ghufran answered 11 years ago
To make exported file display dropdown text instead of ids,
You need to remove from column settings:
$col["formatter"] = "select";
and use clients.name as client_id convention in sql. e.g.
$g->select_command = "SELECT id, invdate, clients.name as client_id, amount, note FROM invheader INNER JOIN clients on clients.client_id = invheader.client_id";
Your Answer
