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
18 replies
Subscribers
7 subscribers
Views
4362 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
We are using MS SQL Server and for one of a column(SharePercent), we have below
Mahesh Sanga
over 8 years ago
We are using MS SQL Server and for one of a column(SharePercent), we have below definition in our CDT.
<xsd:element name="SharePercent" nillable="true" type="xsd:decimal">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column(name=SharePercent columnDefinition="Decimal(15,12)")
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
In the underlying table we have column SharePercent definition as "SharePercent(decimal(15,12), not null)" and we have below values for this column
50.508771927000
19.442982457250
19.442982457250
10.605263158500
We have created a query rule to return these values but the values are being rounded up to 5/6 so, the query rule is returning below values.
50.50877
19.44298
19.44298
10.60526
Should we change the CDT definition to return all decimal values?
OriginalPostID-163295
OriginalPostID-163295
Discussion posts and replies are publicly visible
Parents
0
Mahesh Sanga
over 8 years ago
@vinit I am seeing same values, no change.
@Sagar, Tried your solution, the query rule is returning same values with my existing view. I am creating a dummy table to test your solution.
Thanks
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Mahesh Sanga
over 8 years ago
@vinit I am seeing same values, no change.
@Sagar, Tried your solution, the query rule is returning same values with my existing view. I am creating a dummy table to test your solution.
Thanks
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data