Query around Primary Key in Appian My SQL Database

hi
if you are sure that the 2 column will make unique combination. then no need to declare primary key.
in database table only one column can be primary key (if you define).

instead, just declare column as other columns
and at the time of query use 2 filters combination with AND.

if you declare primary key that means its values must be unique otherwise you will get error.

Hi paragk998 

Thanx for replying!!
My scenario requires that I need to make a composite key the primary key i.e. need to make two columns as primary key.

Also when I open the data type, Appian allows to create only one column as primary key though in XSD (using @Id annotation) as well as in the MySQL table structure we can add two columns as primary key (as shown below).

Any suggestions...

Hi komalc

in that case create CDT from xsd. or database table

hope this will help.

Hi paragk998

Thanx for replying!!

What I am trying to do is: I am modifying my existing CDT and uploading a new version of it wherein I want to make another existing column as primary key.

The screen shot of table is (which is correct):

 

Below is the screen shot with the error which I get when I try to upload new version of my CDT wherein I am making an existing column primary key with @Id annotation

 

Am I missing anything, any suggestion...?

check your xsd

"MYAPPSecurity_DT1"
this column may be having different data type in xsd and table

I guess you took this as "Date" in DB and "string in XSD"

it will be good if you can share your XSD.

check your xsd

"MYAPPSecurity_DT1"
this column may be having different data type in xsd and table

I guess you took this as "Date" in DB and "string in XSD"

it will be good if you can share your XSD.

PFB the xsd:

 

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tns="urn:com:appian:types:MYAPP" targetNamespace="urn:com:appian:types:MYAPP">
  <xsd:complexType name="MYAPP_Security">
    <xsd:annotation>
      <xsd:appinfo source="appian.jpa">
        @Table(name="MYAPP_SECURITY")
	  </xsd:appinfo>
    </xsd:annotation>
    <xsd:sequence>
      <xsd:element name="id" nillable="true" type="xsd:int">
        <xsd:annotation>
          <xsd:appinfo source="appian.jpa">@Id</xsd:appinfo>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="firstName" nillable="true" type="xsd:string">
        <xsd:annotation>
          <xsd:appinfo source="appian.jpa">@Id @Column(length=255)</xsd:appinfo>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="lastName" nillable="true" type="xsd:string">
        <xsd:annotation>
          <xsd:appinfo source="appian.jpa">@Column(length=255)</xsd:appinfo>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
  </xsd:complexType>
</xsd:schema>

 

Screen shot of Table structure: