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.
Anyone can please suggest?
Can you provide with some sample data. So we can understand your issue why the data is not getting sorted.
Sorting when querying the recordType for that third column is not an option?
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?
But it will give us sorted data when page loads. The requirement is to sort the data manually when click on that column in a grid.
Cannot sort by field because it is from a one-to-many record relationship. This error comes up.
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.