Hi, We are trying to retrieve float values from database but the value retu

nikhilh0001 over 8 years ago

Hi,
We are trying to retrieve float values from database but the value returned is rounded to 1 decimal.
For eg: When the value in database is 100.54, queryrule and queryentity return value as 100.5 whereas executequery returns 100.54.
We modified the xsd to include the JPA annotation columnDefinition for an attribute which didnt change the output of the query rule. Please see attached document for further info and let me know if I am missing anything.
Thanks

Appian_RoundingIssue_Forum.docx

Discussion posts and replies are publicly visible

Parents

0 nikhilh0001 over 8 years ago

Thanks for your replies guys, unfortunately, we cannot change the table column data type at this point.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandu
A Score Level 2
over 6 years ago in reply to nikhilh0001

Worth a try, can you re import your xsd changing type="xsd:decimal" for INVOICE_AMOUNT_EX_GST and test.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 chandu
A Score Level 2
over 6 years ago in reply to nikhilh0001

Worth a try, can you re import your xsd changing type="xsd:decimal" for INVOICE_AMOUNT_EX_GST and test.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data