Querying Database With Large Decimal

benjamins over 7 years ago

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?

Discussion posts and replies are publicly visible

Parents

0 davids735 over 7 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 davids735 over 7 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data