Add auditable option to extend entity?

Hi everyone. I had a problem with making an entity field auditable. I have a field added to my entity using Migration. Now I want to edit its options and make the field auditable. I searched a little and I found this link: Github

I had this PHP code and function before:

PHP

public function up(Schema $schema, QueryBag $queries) { $customer = $schema->getTable('orocrm_contact'); $customer->addColumn('is_confirm', 'boolean', ['default' => false, 'oro_options' => [ 'extend' => ['owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => true], 'merge' => ['display' => true], ]]); }

1 2 3 4 5 6 7 8 9 10 11

public function up(Schema $schema, QueryBag $queries)     {         $customer = $schema->getTable('orocrm_contact');           $customer->addColumn('is_confirm', 'boolean', ['default' => false, 'oro_options' => [             'extend' => ['owner' => ExtendScope::OWNER_CUSTOM],             'datagrid' => ['is_visible' => true],             'merge' => ['display' => true],         ]]);       }

After seeing the link I added this option:

PHP

'dataaudit' => ['auditable' => true]

1	'dataaudit' => ['auditable' => true]

And now finally my code looks like this:

PHP

public function up(Schema $schema, QueryBag $queries) { $customer = $schema->getTable('orocrm_contact'); $customer->addColumn( 'is_confirm', 'boolean', [ 'default' => false, 'oro_options' => [ 'extend' => ['owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => true], 'merge' => ['display' => true], 'dataaudit' => ['auditable' => true], ], ] ); }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

public function up(Schema $schema, QueryBag $queries)     {         $customer = $schema->getTable('orocrm_contact');           $customer->addColumn(             'is_confirm',             'boolean',             [                 'default' => false,                 'oro_options' => [                     'extend' => ['owner' => ExtendScope::OWNER_CUSTOM],                     'datagrid' => ['is_visible' => true],                     'merge' => ['display' => true],                     'dataaudit' => ['auditable' => true],                 ],             ]         );       }

I added the option but the problem is that the code is not working and I tried to change this field to true and false but it’s not working and it’s not saving any change history.
It there any command that I should run or is there anything that I’m missing here?
I will appreciate your help. I want to make the field auditable to see what changes by whom has been made.

Thanks,
Aryana.

Topic

[Andrey YatsenkoModerator]

Make sure you have run oro:platform:update command after adding the migration.
Also, notice that migration changes will not be applied when the migration was executed before, so you have to restore the database state to apply it again or write a new migration that will change the entity config.

[a.azadiParticipant]

Thank you for your response.
So to make any changes I need to delete migration then add it again with new configs?
Because I have some data in that field and I can’t restore database then add migration again with new configs. All the data will be lost
Also my Oro version is 1.8.
Isn’t there any other way to make this field auditable without having to restore database state and add the migration again?

[Author]

Replies