Appian Community
Site
Search
Sign In/Register
Site
Search
User
More
Cancel
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
I'm looking for...
State
Verified Answer
+1
person also asked this
people also asked this
Replies
5 replies
Subscribers
13 subscribers
Views
2591 views
Users
0 members are here
Options
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Sorting dollar values in a grid field
xingc
over 4 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 4 years ago
is it mapped to a decimal or text field ?
Cancel
Up
0
Down
Reply
Verify Answer
Cancel
0
aloks0003
A Score Level 2
over 4 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
Up
0
Down
Reply
Verify Answer
Cancel
0
Sachin
A Score Level 1
over 4 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
Up
0
Down
Reply
Verify Answer
Cancel
0
rama
over 4 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
Up
0
Down
Reply
Verify Answer
Cancel
+1
xingc
over 4 years ago
@sathya Srinvasan, it turns out that I need to map it to a decimal field in the cdt. Thanks.
Cancel
Up
0
Down
Reply
Reject Answer
Cancel