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?
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.
Considering at this point we may not be able to upgrade quickly - I changed to use the DSE for this specific table so that I can query the rows without issues.
Thanks for all your insights. Appreciate the professionalism you guys displaying in answering the community.
If you found the advice helpful, please consider marking the response as verified. Thanks!