I am interested in saving a group of process variables to a data store, and sele

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
  • 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>
Reply
  • 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>
Children
No Data