LinQ, GroupBy, C#

Question

Hello,
I have a Master Detail relationship.

Master 1:n Detail
1:n Detail (List)

Via LinQ I would like to group it.
That works too. But I can't reach the ResultView. See the green marker.
What should the query be called?

Thanks in advance for tipps and samples.

The code

   var qryPanelIndex = CurrentPanel.MainList[0].ListDetailBoards.GroupBy(info => info.PanelIndex)
                    .Select(group => new
                    {
                        PanelIndex = group.Key,
                        CountOccurrences = group.Count()
                    })
                    .OrderBy(x => x.PanelIndex).ToList();

            var qryPanelIndex2 = CurrentPanel.MainList[0].ListDetailBoards.GroupBy(info => info.PanelIndex).ToList();

            foreach(var item in qryPanelIndex2)
            {

Answer 1

Hi Markus Freitag,
>>I can't reach the ResultView
According to my understanding, do you want to reach the value of ListPosition in resultView of qryPanelIndex.
If so, you can add this line in the select statement.

.Select(group => new  
                     {  
                         PanelIndex = group.Key,  
                         CountOccurrences = group.Count(),  
                          ListPosition=group.ToArray()  
                     })  

If not, please explain in detail.
Best Regards,
Daniel Zhang

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.