Skip to main content
P
padmanabant852500
April 18, 2025
Solved

Fetching texts more than 4000 characters in expressions

  • April 18, 2025
  • 9 replies
  • 0 views

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?

Best answer by mathieud0001

If you found the advice helpful, please consider marking the response as verified. Thanks!

9 replies

stefanhelzle0001
stefanhelzle0001
April 18, 2025

Which data type do you use in the DB?

P
padmanabant852500Author
April 18, 2025

 [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] , [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05] , [mention:f0523105fd4d4e879f169a28f3dd0ec5:e9ed411860ed4f2ba0265705b8793d05] 

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)

 [mention:f0523105fd4d4e879f169a28f3dd0ec5:e9ed411860ed4f2ba0265705b8793d05]  - Length of Column is already varchar(10000). I also tried LONGTEXT

mathieud0001
mathieud0001
April 18, 2025

24.4 only supports 4000. You need 25.1 for the extra long text.

mathieud0001
mathieud0001
April 18, 2025

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?

yashwantha0914
yashwantha0914
April 18, 2025

Hi [mention:7c6a5e597f2c49368464fbdc8b84ea0e:e9ed411860ed4f2ba0265705b8793d05] 

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.

G
gangadharr0002
April 23, 2025

Simple solution 
Use a!queryEntity() directly from the CDT
It wont truncate 
Thanks!

Terms & ConditionsAccessibility statement