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
9 subscribers
Views
15621 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 10 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
+1
colton.beck
Appian Employee
over 10 years ago
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>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel
rajesh kilaru
over 6 years ago
in reply to
colton.beck
This reply was deleted.
Cancel
Cancel
0
ankita0004
A Score Level 1
over 6 years ago
in reply to
rajesh kilaru
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
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
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!
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
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!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data