Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+2
person also asked this
people also asked this
Replies
16 replies
Answers
4 answers
Subscribers
10 subscribers
Views
16259 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
How do we map a CDT to a database view??/ Any documentation related to vie
raghunandanj3904
Certified Senior Developer
over 11 years ago
How do we map a CDT to a database view??/
Any documentation related to views & CDT is very helpful.
We tried creating a CDT with annotations but it creates a table in the DB. Is there any extra anootations / tags we need to take crae for views. We have created a view in the database in MS SQL....
OriginalPostID-76078
OriginalPostID-76078
Discussion posts and replies are publicly visible
Parents
0
ankita0004
A Score Level 1
over 6 years ago
You have put a primary key in it by @Id annotation
and the database view will have atleast 1 non null unique column
<xsd:schema xmlns:xsd="
www.w3.org/.../XMLSchema"
xmlns:tns="urn:com:appian:types:MP" targetNamespace="urn:com:appian:types:MP">
<xsd:complexType name="Test">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Table(name="Test")
</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="Id" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Id @Column(name="Id", columnDefinition="int")</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel
0
rajesh kilaru
over 6 years ago
in reply to
ankita0004
when i download thw xcript intrestingly it was altering the existing view but i check my XSD it was having all the fields.
Thanks !
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
rajesh kilaru
over 6 years ago
in reply to
ankita0004
when i download thw xcript intrestingly it was altering the existing view but i check my XSD it was having all the fields.
Thanks !
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data