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?...

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 Steven, thank you for your reply. I think I need to be a bit more descriptive about what I'd like to achieve in comparison to the result occurring. I have the parent db/CDT let's call this customers and the child db/CDT contacts. When prompted by the user, I'd like the delete from database node to remove a contact that the user has selected to delete. I would receive the relevant id from this selection and the inputs into the delete from database node would be as follows:

={entity:pv!ENTITY_CONTACTS, identifiers:pv!contactidstodelete}

into the 'data to delete' property. I gather from your answer and the documentation that the contacts id and it's entire row should be deleted from the contacts db, but what is actually occurring is that only the id is removed. The row that should be deleted from the db remains and gets assigned a new id.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 lincolnf454 over 10 years ago

Hi Steven, thank you for your reply. I think I need to be a bit more descriptive about what I'd like to achieve in comparison to the result occurring. I have the parent db/CDT let's call this customers and the child db/CDT contacts. When prompted by the user, I'd like the delete from database node to remove a contact that the user has selected to delete. I would receive the relevant id from this selection and the inputs into the delete from database node would be as follows:

={entity:pv!ENTITY_CONTACTS, identifiers:pv!contactidstodelete}

into the 'data to delete' property. I gather from your answer and the documentation that the contacts id and it's entire row should be deleted from the contacts db, but what is actually occurring is that only the id is removed. The row that should be deleted from the db remains and gets assigned a new id.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data