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
4 replies
Subscribers
8 subscribers
Views
2305 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Grid Sort - we have a use case that requires editable grids (not paging grids) t
Mike
over 10 years ago
Grid Sort - we have a use case that requires editable grids (not paging grids) to be presented to the user sorted by a column (text or integer). The grid starts as empty and data used to populate the grid originates by a user "adding items". When they save and exit the form we want the option to go back to the saved form but have the editable rows or items sorted by some criteria. All of the data in the grid is saved as a CDT (but not yet committed to a database). Is there a way or best practice for specifying the order of rows in a grid or CDT array prior to returning to the form or writing to a database? If not, then the grid presented back to the user will not be logically organized by their criteria. Thanks!...
OriginalPostID-80676
OriginalPostID-80676
Discussion posts and replies are publicly visible
0
revat.anandsongkit
Appian Employee
over 10 years ago
topaginginfo() should help you sort your data. Have a look at
forum.appian.com/.../Scripting_Functions
for some more details and examples.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike
over 10 years ago
thanks, but we were trying to avoid paging grids for this interim step. Our best option is probably using the queryrecord() and datasubset, or query() functions. We were just curious how others applied sorting to editable grids (not paging grids)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike Cichy
Appian Employee
over 10 years ago
topaginginfo() allows you to provide a sort parameter and you do not have to use it within a paging grid.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Mike
over 10 years ago
you guys are right, we just did not consider this with enough rigor. Appreciate the help!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel