Column value display wrong when export CSV in magento 2 admin UI component grid in magento 2

Question

In my custom module admin UI component data grid there is a one column is named "Status" all data display perfectly.

But my problem is when i export data then "Status" column value display 0 OR 1 because in DATABASE value is stored as 0 and 1

And what i want is When i export - then in csv file that status values should be 0 => Pending and for 1 => Active how can i achieve this.

Any help would be appreciated. Thanks.

Answer 1

You need to override getRowData() function of vendor/magento/module-ui/Model/Export/MetadataProvider.php

This function print row data to csv or xml file at the time of export

So you final code will look like:

public function getRowData(DocumentInterface $document, $fields, $options)
{
 $row = [];
 $key = array_search ('status', $fields);
 foreach ($fields as $column) {
 if (isset($options[$column])) {
 $key = $document->getCustomAttribute($column)->getValue();
 if (isset($options[$column][$key])) {
 $row[] = $options[$column][$key];
 } else {
 $row[] = '';
 }
 } else {
 $row[] = $document->getCustomAttribute($column)->getValue();
 if($column == 'status'){
 switch ($row[$key]){
 case 0:
 $row[$key] = self::STATUS_PENDING;
 break;
 case 1:
 $row[$key] = self::STATUS_ACTIVE;
 break;
 case 2:
 $row[$key] = self::STATUS_INACTIVE;
 break;
 case 3:
 $row[$key] = self::STATUS_DISAPPROVED;
 break;
 case 4:
 $row[$key] = self::STATUS_VACATION_MODE;
 break;
 case 5:
 $row[$key] = self::STATUS_CLOSED;
 break;
 }
 }
 }
 }
 return $row;
}