Skip to main content
July 20, 2021
Solved

Fields in CDT

  • July 20, 2021
  • 5 replies
  • 0 views

In my Appian cloud database, I need to figure out what type to list for my resume upload field. In my database I have a blob so what do I use in Appian? I cant use a text....

    Best answer by mikes0011

    Thanks for clarifying - my assumption above was correct, you want the Integer type.

    You can also define your CDT field as Document type if you want; when this connects to the DB it'll just map to an integer anyway.  I usually just use integer as the Appian CDT type, though.  Having the CDT field type be Document doesn't seem to have much of a benefit, for me at least.

    5 replies

    mikes0011
    Brainy
    July 20, 2021

    If you're talking about an Appian Document, you would use Integer, as Appian Doc IDs are an integer behind-the-scenes.

    The Expression Guru
    July 20, 2021

    So I'm creating an interface and I'd like for the user to be able to upload a document, however in my CDT I don't know what to list as the field

    mikes0011
    mikes0011Answer
    Brainy
    July 20, 2021

    Thanks for clarifying - my assumption above was correct, you want the Integer type.

    You can also define your CDT field as Document type if you want; when this connects to the DB it'll just map to an integer anyway.  I usually just use integer as the Appian CDT type, though.  Having the CDT field type be Document doesn't seem to have much of a benefit, for me at least.

    The Expression Guru
    July 21, 2021

    Hi Ashleym,

    You can make use of integer to store only doc id as once you upload document it will give you document object but in DB it will store only doc id