Skip to main content
C
cyasodhac0315
March 5, 2024
Question

SORTING PROBLEM

  • March 5, 2024
  • 11 replies
  • 0 views

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

    11 replies

    harshitb6843
    harshitb6843
    March 5, 2024

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

    C
    cyasodhac0315Author
    March 5, 2024

    i tried that but it not sorting in read grid

    C
    cyasodhac0315Author
    March 5, 2024

    i tried that one but it is not sorting in read only grid

    T
    toshij203104
    April 4, 2024

    Hey,
    Did you get any solution for this?
    I am also facing the same issue.

    shubhama926776
    shubhama926776
    April 4, 2024

    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.

    harshk1671
    harshk1671
    April 8, 2024

    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.

    Terms & ConditionsAccessibility statement