Skip to main content
P
pavans123939
March 5, 2024
Question

Record data issue

  • March 5, 2024
  • 4 replies
  • 1 view

Hello everyone,

I'm encountering an issue with record type. I have a table in my database responsible for storing HTML template code for each user. When retrieving the data through records, I'm not receiving the full length of the HTML code; it's breaking. The column in the database has a VARCHAR data type with a limit of approximately 65,000 characters, while the length of the HTML code string is only 4000 characters. In DB we have full length code.Can anyone provide assistance or suggest a workaround for this problem?

4 replies

stefanhelzle0001
stefanhelzle0001
Brainy
March 5, 2024

Sure. Synced records are limited to 4000 characters for text fields. Switch off sync to allow more.

https://docs.appian.com/suite/help/24.1/records-data-sync.html#when-to-use-data-sync

    P
    pavans123939Author
    March 5, 2024

    Thank you, Stefan, for your response. However, in addition to the retrieval issue, I also need synchronization. This is crucial because users have the ability to add new HTML templates for new joiners through their external system. Without synchronization, how can I ensure that the current data is reflected accurately? Should we implement a scheduler to sync the records at specific time intervals?

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    March 5, 2024

    Not sure what you mean. With enabled sync, Appian keeps a copy of the data in the internal data server. Then, a sync mechanism is needed to keep that copy in sync with the backend system. If you disable sync, any query will always hit the backend system directly.

    Terms & ConditionsAccessibility statement