Skip to main content
D
dikshag
May 24, 2021
Question

Retrieve integer value having more than 10 digits (from third party database)

  • May 24, 2021
  • 4 replies
  • 0 views

Hi All,

In third party database, we have a column (number datatype) which can have more than 10 digit value. How to display the value on Interface.

We have tried mapping type = "xsd:integer" and "xsd:long" and "xsd:int" in XSD 

xsd:int gives Numeric overflow error, on changing it to xsd:integer / xsd:long, it retrieves blank value on query entity but there is value in DB (which has 14 digits)

How to retrieve the values having more than 10 digit value?

Any advice.

Thanks and Regards,
Diksha

    4 replies

    dhananjayk3480
    dhananjayk3480
    May 24, 2021

    Is it necessary to retrieve that in integer?  Can you try that as text in XSD?

    D
    dikshagAuthor
    May 24, 2021

    In database, that column is Number, that's why we not able to try as text in XSD

    mikes0011
    mikes0011
    Brainy
    May 24, 2021

    Have you tried forcing it to pull the value as a decimal?  The decimal data type in Appian can hold a bit larger of a number than Integer.  If that doesn't work, the only other solution for this sort of thing that I've seen has been to pull the value back as a string.

    The Expression Guru
    D
    dikshagAuthor
    May 24, 2021

    We have tried pulling the value as decimal, that works. But we have a concern here. Since the column can allow upto 20 digits value as per the database column description, will changing it to decimal works fine for values upto 20 digits? Will decimal type allow 20 digits value? 

    Terms & ConditionsAccessibility statement