How do we map a CDT to a database view??/ Any documentation related to vie

Here's an example of how you would use each of these:

<xsd:complexType name="Test_Data_Type">
          <xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Table(name="testdatatype")
</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="tdtId" type="xsd:int" nillable="true" >
                    <xsd:annotation>
<xsd:appinfo source="appian.jpa">
                                                            @Id
                                                            @GeneratedValue
                                                            @Column(name="test_datatype")
                                                  </xsd:appinfo>
</xsd:annotation>
</xsd:element>

Here's an example of how you would use each of these:

<xsd:complexType name="Test_Data_Type">
          <xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Table(name="testdatatype")
</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="tdtId" type="xsd:int" nillable="true" >
                    <xsd:annotation>
<xsd:appinfo source="appian.jpa">
                                                            @Id
                                                            @GeneratedValue
                                                            @Column(name="test_datatype")
                                                  </xsd:appinfo>
</xsd:annotation>
</xsd:element>

Can you check the datasource in datastore I think you created the view in different database and now trying to map this on different database

both are same i have a question here

<xsd:schema xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:tns="urn:com:appian:types" targetNamespace="urn:com:appian:types">



do we need to change this or it's just be like that .
Thank you!

Hello,

From XSD prospective there is no difference between a table and a view. As long as the table/view name , the columns along with the primary key exists in the DB as defined in the XSD, the system will not need to create a new table.

Please double check the values .

Can you mention which values that i need to makesure.
Thank you!
as far as i know all the column names are good and i make sure the namespaces.

and the format is looking good is there anything else that i can check for.
Thank you!

Can you please share your XSD and the view/table definition you currently have in the DB.? Comparing both would help.

i created the view in mysql
that's outer join.

It looks like the @ID annotation is missing from the pasted xsd. If you don’t identify @ID, Appian will create a new table with an a_id column that it identifies as the PK.