Hi All, Here is my situation for writing xsd's had 3 c

saratrk over 10 years ago

Hi All,

Here is my situation for writing xsd's

had 3 cdt's

1. client - xsd created - table created
2. employee - xsd created - table created

3. pay

in this pay cdt PK of client and PK of employee are the foreign keys and they are mapped with "many to one" relationship with those 2 (means many records in pay can have single client or employee )

I already have referred forum.appian.com/.../Defining_a_Custom_Data_Type

and written xsd for pay with following annotations.

<?xml version="1.0" encoding="utf-8" ?>
<xsd:schema xmlns="urn:appian:example:assocations:many-to-one" elementFormDefault="qualified" targetNamespace="urn:appian:example:assocations:many-to-one" xmlns:xsd="www.w3.org/.../XMLSchema">

<xsd:complexType name="pay">
--
<xsd:element minOccurs="0" nillable="false" maxOccurs="unbounded" name="clientId" type="client">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@ManyToOne
...

Discussion posts and replies are publicly visible

Parents

0 saratrk over 10 years ago

...@JoinColumn(name="clientidinteger", nullable=false, unique=true)
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
          <xsd:element minOccurs="0" nillable="false" maxOccurs="unbounded" name="employeeID" type="employee">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@ManyToOne
                     @JoinColumn(name="employeeidinteger", nullable=false, unique=true)
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
--
</xsd:complexType>
<xsd:complexType name="client">
--
--
</xsd:complexType>
xsd:complexType name="employee">--
--
</xsd:complexType>
</xsd:schema>

After i upload the xsd appian throws an error, "A type mapping annotation is invalid: The feature/eclass clientId/payDT320 should be a OneToMany but it already has a ManyToMany, OneToOne or ManyToOne annotation (APNX-2-4055-000) "

1. Do i need to define client and employee types in pay as i already uploaded in appian ? (if no, appian is not recognizing the existing typ...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 saratrk over 10 years ago

...@JoinColumn(name="clientidinteger", nullable=false, unique=true)
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
          <xsd:element minOccurs="0" nillable="false" maxOccurs="unbounded" name="employeeID" type="employee">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@ManyToOne
                     @JoinColumn(name="employeeidinteger", nullable=false, unique=true)
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
--
</xsd:complexType>
<xsd:complexType name="client">
--
--
</xsd:complexType>
xsd:complexType name="employee">--
--
</xsd:complexType>
</xsd:schema>

After i upload the xsd appian throws an error, "A type mapping annotation is invalid: The feature/eclass clientId/payDT320 should be a OneToMany but it already has a ManyToMany, OneToOne or ManyToOne annotation (APNX-2-4055-000) "

1. Do i need to define client and employee types in pay as i already uploaded in appian ? (if no, appian is not recognizing the existing typ...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data