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
6 subscribers
Views
3538 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 12 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
Mike
over 12 years ago
Here's the start of my schema. It ignores the @ID etc and generates a_id anyway:
xsd:schema
targetNamespace="
scrippsnetworksdev.appiancloud.com/.../"
xmlns:types611="
scrippsnetworksdev.appiancloud.com/.../"
xmlns:xsd="
www.w3.org/.../XMLSchema">
<xsd:complexType name="RR_Resource">
<xsd:annotation>
<xsd:documentation><![CDATA[The CDT to contain information for all employees.]]></xsd:documentation>
</xsd:annotation>
<xsd:sequence>
<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 name="employee_ID" nillable="true" type="xsd:int"/>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Mike
over 12 years ago
Here's the start of my schema. It ignores the @ID etc and generates a_id anyway:
xsd:schema
targetNamespace="
scrippsnetworksdev.appiancloud.com/.../"
xmlns:types611="
scrippsnetworksdev.appiancloud.com/.../"
xmlns:xsd="
www.w3.org/.../XMLSchema">
<xsd:complexType name="RR_Resource">
<xsd:annotation>
<xsd:documentation><![CDATA[The CDT to contain information for all employees.]]></xsd:documentation>
</xsd:annotation>
<xsd:sequence>
<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 name="employee_ID" nillable="true" type="xsd:int"/>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data