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
Discussion posts and replies are publicly visible
Similar Thread go through this they suggest few approaches may be one of them would help
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.
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.....
I have used the same approach using relationships as you mentioned. But it says one to many relationships when sorting data. Can you please elaborate how to use second approach?
Sorry, I mislead you Sorting in one-many relationship is not possible.Query Related Record it helps you to sort data in relationship before getting it . Not on grid i guess. May be custom record field might help you give it a try.