Hi forum, I am using the Delete from Data Store Entities smart servic

Hi Gary. Here are the steps I took to make this node work for me using a datastore named dsFruit as an example.

1. Ensure you have a process variable of type int holding the unique id(s) of the row(s) you would like to delete form your database. Note that you can delete a single entity or many entities by either assigning this variable as single or multiple.

2. Ensure that you have created a process variable of type "Data Store Entity" and assign the value to you datastore (see screenshot below)

3.In the value entry on the delete from database node, enter in the following expression

={entity:pv!dsFruit, identifiers:pv!FruitIdentifiers}

Where entity is the variable from point 2 and identifiers is the variable from point 1. See second screenshot. Hope this helps.

Hi Gary. Here are the steps I took to make this node work for me using a datastore named dsFruit as an example.

1. Ensure you have a process variable of type int holding the unique id(s) of the row(s) you would like to delete form your database. Note that you can delete a single entity or many entities by either assigning this variable as single or multiple.

2. Ensure that you have created a process variable of type "Data Store Entity" and assign the value to you datastore (see screenshot below)

3.In the value entry on the delete from database node, enter in the following expression

={entity:pv!dsFruit, identifiers:pv!FruitIdentifiers}

Where entity is the variable from point 2 and identifiers is the variable from point 1. See second screenshot. Hope this helps.