XSDs annotations getting lost during creating/updating a CDT

Sandro Oberdorfer

A Score Level 2

over 8 years ago

Heya all,

I just created some new CDTs via importing some XSDs and updated another couple of existing CDTs via XSD-uploads. In each case I only added one annotation to index a field. Here is one example:

Before:
<xsd:element name="leadId" nillable="true" type="xsd:int" />

After my changes:
<xsd:element name="leadId" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Index(name="LMW_ProcessData_leadId")</xsd:appinfo>
</xsd:annotation>
</xsd:element>

So after I made these changes and created/updated I took a look into the XSDs to double check via downloading the CDTs XSD from Appian, but my annotation was completely gone. It looked like this again:
<xsd:element name="leadId" nillable="true" type="xsd:int" />

Afterwards I looked into the database and behold: The index was actually there. So basically I got my...

Discussion posts and replies are publicly visible

0 Sandro Oberdorfer
A Score Level 2
over 8 years ago

Hey @aloks176, I quite simply want to optimize my database queries. The datamodel has a couple of smaller CDTs and running all those queries without indexing hurts performance. Plus I wanted a solution that is ideally automatically deployed with the application instead of having to do that extra.

Thanks for all your help so far guys!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandu
A Score Level 2
over 8 years ago

Hi sandroo, I too tried that, it seems @table annotation doesn't have Indexes attribute that resulted me giving the same error. I clearly see in the URL
forum.appian.com/.../Custom_Data_Types_from_XSD.html
@Column (with additional attributes: uniqueKey and index).
So Index attribute should work for @column annotation. I can't able figure out why its not working for my scenario also.

Will it not be possible to create Index from the DB side?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel