I have a View in the Appian Cloud database with a column that concatenates some values, lets call it column "CODES".
I started in our dev environments creating a CDT from Table/View and verifying the datastore.
I then did a distribution to the test environment of the CDT, View and Datastore. While verifying in test environment I get an error that CODES is not a MEDIUMTEXT, it's a LONGTEXT. Not knowing what to do I try to create the CDT in test environment and actually the generated CDT in this environment is different that the one that was generated in dev, even though the database view is the same.
Any suggestions on how to solve this issue? The thing is that I don't know in a production environment which datatype Appian will choose, and I don't want to create objects manually in production, I shouldn't even be able to.
Thank you!
Discussion posts and replies are publicly visible
Putting the XSD to mediumtext moves the issue from one environment to the other, when I change it it stops verifying in Test and works in Dev.
As to setting the column to longtext, how do i do it for a database view? I had searched on the web but hadn't find a way to define the type
You have to do it on the underlying table (the one that the view uses).
Speaking of which, I see that you posted the structure for the view, but could you check the structure of the underlying table?