Entity Extension CRUD Actions
  • 06 Jun 2022
  • 2 Minutes to read
  • Dark
    Light
  This documentation version is deprecated, please click here for the latest version.

Entity Extension CRUD Actions

  • Dark
    Light

User Define Types
All the steps used for CRUD actions cannot be search for. Users will need to manually navigate to the Flow Category User Defined Types. In a default Decisions installation, it will be the last category on the bottom in the 'Steps' tool box.

Preparation 

If the Entity Structure has already been created, Skip to the "Entity Extension" Heading of this document

This article will demonstrate using the Create, Selective Update, and Delete Flow steps for Decisions Entity Extension Structure. Before continuing to the next section, create an Entity Data Structure in Decisions with the following field names:

Person
FirstnameString
LastnameString
DOBDate time

Entity Extension

After the Entity Data Structure is created, create an Entity Extension, tie it to the previously created Entity, and that has the following fields:

AdditionalPersonInfo
SSNString
EmployedBoolean
AddressString

Create 

To create an Entity that contains an Entity Extension

  1. Create a Flow
  2. Expand the 'User Define Types' category
  3. Expand the Entity Extensions category
  4. Expand the 'AdditionalPersonInfo_Person' datatype
  5. Drag over the 'Create AdditionalPersonInfo_Person' step onto the flow canvas
  6. Connect it to the 'Start' and 'End' step and change the 'input type' to 'Build Data'
  7. Set constant values for 'Address', 'Employed', and 'SSN'
  8. Set the 'Person' input to 'Select From Flow' and map a Person object from the Fetch Entities to the 'Person' input.


Click the 'Debug' button to run the flow. Decisions will add that Entity Extension properties to the selected Entity Object.

Update

To update an existing record in a Database Structure the 'Edit AdditionalPersonInfo'. This is found in User Defined Types -> Database Structures -> Person. The 'Edit AdditionalPersonInfo' step will change every data field in the object even if the user only changes one data field.  In order to change any record in a data structure, the 'Fetch Entities' step will need to be used to get that particular record. Then pass the Id of the record to be changed into the Edit.

'Edit AdditionalPersonInfo' Step

Be careful Using The 'Edit' Step
If the 'Edit' step is used in to change one field, that field will be changed, and all the other fields will be set to Null or Empty


Delete

For Entity Extensions, there are no delete steps in the User Defined Types -> Entity Extensions -> AdditionalPersonInfo. In order to remove an Entity Extension, the 'Edit AdditionalPersonInfo' will be used. This is done by mapping the Person Entity from the 'Fetch Entitites' step into the 'Person' input on the 'Edit AdditionalPersonInfo' step. Then set the input type on the 'AdditionalPersonInfo' to 'Build Data', and leave all the values to 'Ignore.' When the Flow is run, it will remove the additional Entity Extension values that were on tied to the Person Entity. 



Was this article helpful?