We have a column in the Appian database table with data type as 'long text'. We want to facilitate storing and retrieving string around 8000 characters size in this table column. This will be a master data and will not be fetched in interfaces. (Also it may not always be 8000 in string length)
But we will fetch this column in the expression rule for some evaluation and running rules.
We are noticing that this column with long text is getting truncated in the expression rule when we retrieving the data.
Our Record Type does not show any option to select "Extra Long Text" when creating a Record Type from this database table.
This documentation indicates that we should be able to map the varchar or text to 'Extra Long Text' https://docs.appian.com/suite/help/25.1/about-data-sync.html
Am I missing anything here?
Discussion posts and replies are publicly visible
Which data type do you use in the DB?
I'm assuming that it's getting truncated because the type in the Record is text. What's the type of the column in the database?
Hi padmanabant852500 Can you check the Appian version that you are using, "Extra Long Text" type is available in 25.1 version.so, if you are using any other versions please update, or else you can increase the length of the column in the database.
Stefan Helzle , Mathieu Drouin , Yashwanth Akula
I'm trying varchar(10000) now. It was 'LONGTEXT' earlier.
I'm not seeing the the 'Extra Long Text' for both in Record Type.
I see that we are in Version '24.4'. RDBMS version 10.6.16-MariaDB-log.
What is the best option to make the record type fetch all the string rather concatenating.
(We want to fetch this only in expressions and this will not be used in interfaces)
Yashwanth Akula - Length of Column is already varchar(10000). I also tried LONGTEXT
24.4 only supports 4000. You need 25.1 for the extra long text.