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
3 replies
Subscribers
8 subscribers
Views
1182 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I am working with an external oracle database I am using an external data s
christophers739
Certified Associate Developer
over 8 years ago
I am working with an external oracle database
I am using an external data store to get 2 values that I have to search by, unfortunately those values are stored on the database as:
number(15)
Which as far as I can tell is a number 15 character’s long which is longer than the largest xsd data type I can find, long, it’s also possible that this will overflow the number(integer) field in apian as well but I don’t know about that.
I do not have to display this number, just compare it.
Does anyone know a way to get this number in a appian friendly format, so I can query using it?
OriginalPostID-189998
OriginalPostID-189998
Discussion posts and replies are publicly visible
Parents
0
Jim Schweitzer
Certified Lead Developer
over 8 years ago
Not possible to perform calculations on a number that large in Appian. You could map it as a string and display it, but I think Appian only supports calculations up to 10 or 11 digits. I'm on mobile, so I can't link to the docs.
Maybe look into a stored procedures or a generated column in a view as a workaround?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Jim Schweitzer
Certified Lead Developer
over 8 years ago
Not possible to perform calculations on a number that large in Appian. You could map it as a string and display it, but I think Appian only supports calculations up to 10 or 11 digits. I'm on mobile, so I can't link to the docs.
Maybe look into a stored procedures or a generated column in a view as a workaround?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data