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
Replies
9 replies
Subscribers
5 subscribers
Views
3204 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
I am interested in saving a group of process variables to a data store, and sele
Mike
over 11 years ago
I am interested in saving a group of process variables to a data store, and selectively deleting rows in that data store, or modifying particular entities in the data store. I have not come upon the correct combination of settings that will allow me to do this using combinations of "Delete from Data Store Entity" or using "Query Database". I seem to be adding to my data store when I try to delete, which is described in the documentation if my index is wrong. I am trying to use a process variable as my index, but its a multiple variable, so it looks like "; 3" if I try to delete the third row in my table. Any quick and simple suggestions on how to modify or delete data in data stores?...
OriginalPostID-62243
OriginalPostID-62243
Discussion posts and replies are publicly visible
Parents
0
Annelise Dubrovsky
Appian Employee
over 11 years ago
In your example, you have a closing tag in both the empID_int and employee_ID elements.
The annotation needs to be *within* the element that you want to mark as the PK.
<xsd:element name... >
<xsd:annotation>
</xsd:annotation>
</xsd:element>
Notice how your "<xsd:element name..." ends with "/>" instead of ">". Here's an updated snippet:
<xsd:element name="empID_Int" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Id
@GeneratedValue
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Annelise Dubrovsky
Appian Employee
over 11 years ago
In your example, you have a closing tag in both the empID_int and employee_ID elements.
The annotation needs to be *within* the element that you want to mark as the PK.
<xsd:element name... >
<xsd:annotation>
</xsd:annotation>
</xsd:element>
Notice how your "<xsd:element name..." ends with "/>" instead of ">". Here's an updated snippet:
<xsd:element name="empID_Int" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Id
@GeneratedValue
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data