Workflow @create_entity

Hi,

I created a new workflow where I have EntityA.
I want to create EntityB fill columna and columnb and set EntityA.

Error is a DB error:

message: “Can’t create entity AppBundle\Entity\Entityb. An exception occurred while executing ‘INSERT INTO app_entityb (columna, columnb, createdAt, updatedAt, workflow_item_id, workflow_step_id, entitya_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)’ with params [null, null, “2015-04-23 10:22:38”, “2015-04-23 10:22:38″, null, null, 4]:↵↵SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘columna’ cannot be null”
Name

transition.yml

start_entityb: label: 'Start entityb' step_to: new_entityb is_unavailable_hidden: true acl_resource: app_entityb_create frontend_options: icon: 'icon-ok' class: 'btn-primary' transition_definition: start_entityb_definition form_options: attribute_fields: entityb_columna: options: required: true constraints: - NotBlank: ~ entityb_columnb: options: required: true constraints: - NotBlank: ~

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

start_entityb:                 label: 'Start entityb'                 step_to: new_entityb                 is_unavailable_hidden: true                 acl_resource: app_entityb_create                 frontend_options:                     icon: 'icon-ok'                     class: 'btn-primary'                 transition_definition: start_entityb_definition                 form_options:                     attribute_fields:                         entityb_columna:                             options:                                 required: true                                 constraints:                                     - NotBlank: ~                         entityb_columnb:                             options:                                 required: true                                 constraints:                                     - NotBlank: ~

transition_definition.yml

start_entityb_definition: post_actions: - @create_entity: # create a entityb class: AppBundle\Entity\Entityb attribute: $.result.entityb flush: true data: entitya: $entitya columna: $entityb_columna columnb: $entityb_columnb - @redirect: # redirect to entityb view page route: 'app_entityb_view' route_parameters: id: $.result.entityb.id

1 2 3 4 5 6 7 8 9 10 11 12 13 14

start_entityb_definition:                 post_actions:                     - @create_entity: # create a entityb                         class:     AppBundle\Entity\Entityb                         attribute: $.result.entityb                         flush: true                         data:                             entitya: $entitya                             columna: $entityb_columna                             columnb: $entityb_columnb                     - @redirect: # redirect to entityb view page                       route: 'app_entityb_view'                       route_parameters:                           id: $.result.entityb.id

attributes.yml

entityb: label: entityb property_path: salesfunnel.entityb entityb_square_meter: label: Square meter property_path: salesfunnel.entityb.columna type: float entityb_room_type: label: Room type property_path: salesfunnel.entityb.columnb type: string

1 2 3 4 5 6 7 8 9 10 11

entityb:                 label: entityb                 property_path: salesfunnel.entityb             entityb_square_meter:                 label: Square meter                 property_path: salesfunnel.entityb.columna                 type: float             entityb_room_type:                 label: Room type                 property_path: salesfunnel.entityb.columnb                 type: string

How to set the values from workflow form to the new Entity?

Thanks and

best regards

Topic

[Yevhen ShyshkinParticipant]

Hello, cardiac.

I see two possible issues here.

1) In your transition “start_entityb” (transition.yml) you use attributes entityb_columna and entityb_columnb, and in the same time they are not defined in list of attributes (attributes.yml). You have to define attributes first to use them in transition form.

2) Parameter “data” of “@create_entity” action uses keys as property paths – so, please, make sure that entity AppBundle\Entity\Entityb has fields called columna/columnb or has appropriate setters setColumna/setColumnb.

To debug this case you can add breakpoint here and check what data is there.

Also you can check how Qualify transition works in Sales Funnel flow: attribute, transition, transition definition.

Please, write here results of your investigation.

[cardiacParticipant]

Thank you for your help. I had an error in attributes.yml. You are right ;)

[Author]

Replies