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
10604 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
Sally Mason
Appian Employee
over 7 years ago
Just adding to the previous comment, in this case though, storing the decimal places requires more space, eg storing 1 compared to 1.1234567, so applying that to 9000000000, 9000000000.00 is not the same and needs more 'space', to which it exceeds the limit.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sally Mason
Appian Employee
over 7 years ago
Just adding to the previous comment, in this case though, storing the decimal places requires more space, eg storing 1 compared to 1.1234567, so applying that to 9000000000, 9000000000.00 is not the same and needs more 'space', to which it exceeds the limit.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data