Querying Database With Large Decimal

Im having an issue where if I have a large decimal that I am using in my queryFilter to query the database with, the query crashes.

a!queryFilter(
field: "minDevCost",
operator: "<=",
value: ri!devCost
),
a!queryFilter(
field: "maxDevCost",
operator: ">=",
value: ri!devCost
)

The CDT field is a numeric (Decimal).

If I enter in a decimal of 9000000000, the query crashes.
if I enter in a decimal of 9000000000.00, then the query processes fine.

However, I cannot force the number to have 2 decimal places as if I use the text function
text(9000000000, "###############.##")
I get back N/A

I tried the fixed function as well and this did not work.

Any other suggestions to get this to work?

OriginalPostID-257369

  Discussion posts and replies are publicly visible

Parents
  • You've exceeded the limit of Appian Integer value, which renders infinity, but you're still well within the limits of 15 or so significant digits for a double precision floating point. Your issue is Appian automatically assuming any value without a decimal part is not a decimal, interpreting your number as an integer and setting it to infinity.

    You probably want to make absolutely sure that you cast this value as a decimal type when defining it. Something like:

    value: todecimal(ri!devCost)

    I hope this helps.
Reply
  • You've exceeded the limit of Appian Integer value, which renders infinity, but you're still well within the limits of 15 or so significant digits for a double precision floating point. Your issue is Appian automatically assuming any value without a decimal part is not a decimal, interpreting your number as an integer and setting it to infinity.

    You probably want to make absolutely sure that you cast this value as a decimal type when defining it. Something like:

    value: todecimal(ri!devCost)

    I hope this helps.
Children
No Data