Mryntu

I created an custom attribute for orders:

UpgradeSchema.php

<?php



use MagentoFrameworkSetupUpgradeSchemaInterface;
use MagentoFrameworkSetupSchemaSetupInterface;
use MagentoFrameworkSetupModuleContextInterface;

class UpgradeSchema implements UpgradeSchemaInterface

 /**
 * Upgrades DB schema for a module
 *
 * @param SchemaSetupInterface $setup
 * @param ModuleContextInterface $context
 * @return void
 */
 public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
 
 $setup->startSetup();

 $quote = 'quote';
 $orderTable = 'sales_order';

 $setup->getConnection()
 ->addColumn(
 $setup->getTable($quote),
 'mediabasebestellnummer',
 [
 'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
 'length' => 255,
 'comment' =>'MediabaseNummer'
 ]
 );
 //Order table
 $setup->getConnection()
 ->addColumn(
 $setup->getTable($orderTable),
 'mediabasebestellnummer',
 [
 'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
 'length' => 255,
 'comment' =>'MediabaseNummer'
 ]
 );

 $setup->endSetup();
 

Right now my question is how get the custom attribute when I have an order.
This is NOT working:

$custom = $order->getCustomAttribute('mediabasebestellnummer');

Thanks for any help!

check if the column is created in sales_order table

Now getting the values

 $order->getMediabasebestellnummer();

Or

$order->getData('mediabasebestellnummer');

For adding the data

 $order->setMediabasebestellnummer('test value')->save();

or

 $order->setData('mediabasebestellnummer','test value')->save();

or

$data = array('mediabasebestellnummer'=>'test');
$order->setData($data)->save();`

Make sure you have file fieldset.xml in your module to convert data from quote to order.

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:noNamespaceSchemaLocation="urn:magento:framework:DataObject/etc/fieldset.xsd">
 <scope id="global">
 <fieldset id="sales_convert_quote">
 <field name="mediabasebestellnummer">
 <aspect name="to_order" />
 </field>
 </fieldset>
 </scope>
</config>