Skip to main content
S
snehay0001
June 2, 2022
Question

Field type in parent CDT is getting changed from document to anytype when child CDT is updated

  • June 2, 2022
  • 11 replies
  • 0 views

Hello All,

We observed one issue

1. Parent CDT -> one of the columns type is document

2. We updated the child CDT (added a new column) upon updating the child CDT, the parent CDT filed type changed from document to anytype.

Did anyone face the same issue?

11 replies

stefanhelzle0001
stefanhelzle0001
Brainy
June 2, 2022

I do not really understand.

In the parent there is a field of type document. Then there is some, probably nested, child CDT.

What do you mean with "added a new column"? Is this about a new field?

Where do you see this behaviour? Do you have some code you can share?

S
snehay0001Author
June 3, 2022

Hello

1. Parent CDT with document field and child CDT.

2.

 2.1 Child CDT before the update

2.2 Added new field in the CDT 

3. After Step 2.2 parent CDT's fields type changed from document to number

Thank You,

Sneha.

 

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 3, 2022

    The data type "document" does only exist inside Appian. If you modify it outside of Appian, it will turn into an integer as this is the underlying representation.

    I consider this to be expected behaviour.

    BTW, I recommend to manage the data structures only in CDTs and let Appian maintain the DB schema. I think this fits the low-code spirit of Appian way better than hand crafted XSDs or SQL scripts.

    julienc
    julienc
    June 2, 2022

    Did you download the XSD, update it to add the field, then upload it to create a new version (as recommended by Appian)?

    S
    snehay0001Author
    June 3, 2022

    Yes, I tried to add a new field in both ways by updating the XSD/ updating from the designer.

    Terms & ConditionsAccessibility statement