Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
+2
person also asked this
people also asked this
Replies
10 replies
Subscribers
5 subscribers
Views
4940 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi forum, I am using the Delete from Data Store Entities smart servic
lincolnf454
over 10 years ago
Hi forum,
I am using the Delete from Data Store Entities smart service in a process. Whenever I try to assign the data store to delete from when configuring the properties, the node does not retain the data store I have assigned in the input. (see screenshot attachment). I am using Appian 7.2. Does anyone else have this issue?...
OriginalPostID-92395
OriginalPostID-92395
Discussion posts and replies are publicly visible
Top Replies
lincolnf454
over 10 years ago
+2
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)…
Parents
0
lincolnf454
over 10 years ago
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.
Cancel
Vote Up
+2
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
lincolnf454
over 10 years ago
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.
Cancel
Vote Up
+2
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data