is there a way to retrieve more than 4000 characters from database using either records type or data store entity
Discussion posts and replies are publicly visible
If you use a data store entity, you can return more than 4000 characters, but currently using synced records supports 4000 or fewer. Can you provide a bit more context about your use case? What information are you storing in that column? How do you plan to use it in your application?
actually I got the solution, I implemented the stored procedure option and directly call it through the database. Now it is working perfectly fine.
Could you explain that a bit? dealing with a similar issue. Thanks
You can retrieve more than 4000 characters from a database in Appian using paging or chunking techniques to bypass the limit imposed by some database systems.
Shubham Aware said:paging or chunking techniques
What is that? Never heard of it in an Appian context !?!
Please read this first: https://docs.appian.com/suite/help/24.1/records-data-sync.html#when-to-use-data-sync
If your use case does not fit synced records, just disable sync and you can query as much data as you need. Even fields with 4001 characters or more.
Is there any way to do it without disabling sync? I was thinking something related to data store entities.
DSEs are legacy and do not support sync. So, using DSE, you can query without limits, but loose the benefit of using records.
So is there no way around the character limit without disabling sync or using DSEs?
If you know about the requirement in advance, I'm guessing (but i haven't tried) that you could rig up some sort of "link table" solution for a given field that needs to (sometimes) store >4000 characters, which could be cobbled back together at runtime?
Not as of now. I am sure Appian will raise this limitation in some future version.