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
10935 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
Karthik
over 7 years ago
application-server.log should be updated when there is any error at any rules or PMs.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Karthik
over 7 years ago
application-server.log should be updated when there is any error at any rules or PMs.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data