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
7 replies
Subscribers
7 subscribers
Views
2462 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi, I am executing a query through executequery() expression rule. To the q
sikhivahans
over 11 years ago
Hi,
I am executing a query through executequery() expression rule. To the query, i am passing an number(integer) input dynamically. The input numbers are like this : 1363852714818, 1363852714900 etc. But while passing the input as parameter, the query is unable to accept this much big number. Could anyone provide a solution for this asap?
Thanks in advance.....
OriginalPostID-61634
OriginalPostID-61634
Discussion posts and replies are publicly visible
Parents
0
mathanap
over 11 years ago
The nast numbers like as you have, can't be stored in Number(Integer). You can store tem only on Number(Decimal). In CDT too, you need to annotate 'Decimal or Double' for that sepecified column with large number. Thus by you can avoid problems while storing that large numbers in DB.
Regarding XSD annotation refer :
forum.appian.com/.../Defining_a_Custom_Data_Type
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mathanap
over 11 years ago
The nast numbers like as you have, can't be stored in Number(Integer). You can store tem only on Number(Decimal). In CDT too, you need to annotate 'Decimal or Double' for that sepecified column with large number. Thus by you can avoid problems while storing that large numbers in DB.
Regarding XSD annotation refer :
forum.appian.com/.../Defining_a_Custom_Data_Type
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data