when export grid data it shows database values how i resolve this problem

Questionswhen export grid data it shows database values how i resolve this problem
krishna asked 6 years ago

issue image

5 Answers
Abu Ghufran Staff answered 6 years ago
Abu Ghufran - Dev Team
Grid 4 PHP Framework
pcattani answered 8 months ago

I think I am having the same problem.  That link is no longer valid, Abu.  Can you reproduce the information here?


I have a table which has the column name ‘class’ which can contain one of two values ‘user’ or ‘admin’.


All my users but one are a ‘user’, but when I export, they all have class ‘admin’.  The admin has a blank class.


My column is defined like this:


$class_vals = ‘user:user;admin:admin’;

$col = array();
$col[“title”] = “Class”; // caption of column, can use HTML tags too
$col[“name”] = “class”; // grid column name, same as db field or alias from sql
$col[“width”] = “50”; // width on grid
$col[“hidden”] = false;
$col[“editable”] = true;
$col[“edittype”] = “select”;
$col[“formatter”] = “select”;
//$col[“formoptions”] = array(“elmsuffix”=>'<font color=red> *</font>’);
$col[“editoptions”] = array(“value” => $class_vals, “separator” => “:”, “delimiter” => “;”);

Mike answered 8 months ago

Check-out the Demos Section \demos\appearance\dropdown.php

I think the broken link is to the old support site. If you use the search you should be able to find the referenced information – but it’s quite old, a lot of updates have happened and I think this issue was fixed, depending how old your version is.

This is the current link for that old support article I found by searching:

Exporting Grid with Dropdowns only displays values



pcatt answered 8 months ago

Strange… I have a very new version (this year!).

Abu Ghufran Staff replied 8 months ago

Please share your complete code for review and regenerate the case.
You can directly email me at my email address.

Your Answer

7 + 10 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?