Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Verified Answer
+1
person also asked this
people also asked this
Replies
5 replies
Subscribers
8 subscribers
Views
3009 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Sorting dollar values in a grid field
xingc
over 7 years ago
I have a grid field with text columns. The values populating these fields are pulled from a stored procedure. In the database the values are stored as decimals. I am having problem with sorting the column.
OriginalPostID-256453
Discussion posts and replies are publicly visible
0
Sathya Srinivasan
Appian Employee
over 7 years ago
is it mapped to a decimal or text field ?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
@xingc try checking, whether did you use field parameter for grid text column or not. By the way what problem are you facing
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sachin
A Score Level 1
over 7 years ago
If you are have a sorting problem in the grid,may be it's because you did not defined sort in the paging info, by default if not defined it will return unsorted result try the below code in your sail.
a!pagingInfo( startIndex: 1, batchSize: 6, sort: a!sortInfo( field: "cost_decmal", ascending: true or false ) )
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Rama Thummala
Certified Lead Developer
over 7 years ago
@xingc,
Once the data is retrieved, the respective field is decimal and you displaying it after formatting.
If I understand it correctly, in grid configure the field with the respective field that is mapped to database column.And the display value (formatted text) map to value.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
+1
xingc
over 7 years ago
@sathya Srinvasan, it turns out that I need to map it to a decimal field in the cdt. Thanks.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Reject Answer
Cancel