Skip to main content
manjit.1486
Known Participant
Jun 7, 2024 5:32 PM UTC
Question

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

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
    Inspiring
    Jun 7, 2024 5:46 PM UTC

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

    manjit.1486
    Known Participant
    Jun 7, 2024 6:31 PM UTC

    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
    Inspiring
    Jun 10, 2024 10:09 AM UTC

    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.....