Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
15 replies
Subscribers
7 subscribers
Views
10930 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
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?
OriginalPostID-257369
Discussion posts and replies are publicly visible
Parents
0
benjamins
over 7 years ago
todecimal doesnt work either. The input is already a numeric(decimal) anyway.
Just to be clear, the issue is not with my code, it appears to be an issue with the expression editor. When a large number is entered into the expression field, the value is infinity which causes the rule to fail when trying to test the rule. Entering the same value into the value field works fine.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
benjamins
over 7 years ago
todecimal doesnt work either. The input is already a numeric(decimal) anyway.
Just to be clear, the issue is not with my code, it appears to be an issue with the expression editor. When a large number is entered into the expression field, the value is infinity which causes the rule to fail when trying to test the rule. Entering the same value into the value field works fine.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data