Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
5 subscribers
Views
3228 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
Trying to map a CDT to a view in my database. XSD attached. When I attempt to cr
John Stretton
over 8 years ago
Trying to map a CDT to a view in my database. XSD attached. When I attempt to create a data store entity for this CDT, Appian wants to execute the following line in a DDL script:
add aid numeric(19,0) not null;
Obviously this fails because you can't add a column to a view. What am I missing? How can I get Appian to stop trying to add this column?
RFP_DeadlineAlerts.xsd
OriginalPostID-171284
OriginalPostID-171284
Discussion posts and replies are publicly visible
Parents
0
Jorge Sanchez
Appian Employee
over 8 years ago
Try using backticks when defining names with underscores:
@Column(name="`a_id`",columnDefinition="int",nullable=false) @Id
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Jorge Sanchez
Appian Employee
over 8 years ago
Try using backticks when defining names with underscores:
@Column(name="`a_id`",columnDefinition="int",nullable=false) @Id
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data