SORTING PROBLEM

Question

Cannot sort by field because it is from a one-to-many record relationship.

Shubham Aware · Answer

Sorting by a field from a one-to-many relationship in Appian grids isn't directly supported. Consider these solutions: 
 Aggregate data from the related table into a single value or array in the main table for sorting within the grid view. Create a database view incorporating the sorting logic and joining tables. Use this view as the data source for your grid.

Harsh Kumar Agarwal · Answer

Sorting is not supported for one to many relationship columns in read only grid. If you are trying to display multiple values of child table for one row of parent table then it is not the best fit for read only grid. Instead, you can try rendering the grid on child table and also display columns of parent table using many to one relationship. this way sorting will work.

Harshit Bumb (Appyzie) · Answer

docs.appian.com/.../fnc_system_relatedrecorddata.html

SORTING PROBLEM

Top Replies