Skip to main content
manjit.1486
manjit.1486
June 7, 2024
Question

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

  • June 7, 2024
  • 11 replies
  • 0 views

Hello Folks,

I have a case when data need to be sorted in one to many relationship. 

For example: There is a grid where one column is not sorted because it has one-to-many record relationship. However, I cannot change the relationship. Can anyone guide me on this please?

Thanks

    11 replies

    venkatrea696188
    venkatrea696188
    June 7, 2024

    Similar Thread go through this they suggest few approaches  may be one of them would help

    manjit.1486
    manjit.1486Author
    June 7, 2024

    I have checked but there is one thing.
    For example I have three records.

    Parent table: Employee

    second table: Employee links

    third table: Department name

    One is parent table and need to show all the fields in a grid from a parent table except one field coming from third table.

    Parent table has one to many relationship with second table and that second table has other relationship many-to-one with third table.

    That one field is coming from third table. What to do in this case? I cannot render the grid data from child table.

    venkatrea696188
    venkatrea696188
    June 10, 2024

    pv!record.relationship.employeelinks.relationship.department
     

    I think we can directly refer it , Can't we ?? .If not get the data of third table and use index.....

    Terms & ConditionsAccessibility statement