Group By on rowExpanded fetching data from API creating null rows

[veerareddyobula]

Requirements –

1. Manage pagination at each group level.
2. Load group on demand when user clicks on row expand.
   https://i.pinimg.com/originals/81/ad/be/81adbef7d4758b011ad43b2315164395.png
   https://i.pinimg.com/originals/31/92/52/31925269ceafbcaecdef762c3ee2ef2d.png

---

The ui grid displays columns : Severity, Name, Status, caseID, AssetID, AssetName, SiteName ....soon total 12 columns.
Issue –

1. Apply Grouping on Severity, Status, AssetId, caseId columns.

2. By default grid displays Severity group as level zero.
   https://i.pinimg.com/564x/a5/aa/f3/a5aaf37583f059702615cfbb62dca7ff.jpg

3. When we expand Severity “One” entity, application request API to fetch top 100 distinct status where severity is equal to one.
   https://i.pinimg.com/564x/fa/1d/23/fa1d2324b2af45b4195426a99a5310cd.jpg

4. On expand of Closed status entity the application request API to fetch top 100 distinct AssetId list where status is equal to closed and severity id equal to one
   https://i.pinimg.com/564x/b8/8b/23/b88b23ed00029f5a4785a68eae083c3a.jpg

5. At this level we can observe some empty rows i.e. null value rows are created. The application refined dataset correctly.

6. Issue Root Cause Guess – as the source data set which is injected to ui-grid is refined correctly based on the grouping conditions & API response the UI-Grid visibleRowCatche is not updated when compared with bonded dataset

[veerareddyobula]

I am working to replicate this issue with Plunkr. In this scenario we are loading group data when user expand the entity. To replicating this in plunkr I am facing challenges with API`s to make pagination & group-by data append on rowExpanded. Updating brief work flow
--- Initially we are fetching data for all columns. when user performs group by action the API returns distinct top 100 entries for specific column (grouped column) hence remaining fields in the record will not present i.e. will be null. Application creates this as new object & binds with gridoptions.data (removing old data).
-- Once user expanded the row application performs another API call to fetch related top 100 records order by created date. If the second level is leaf the application API returns data for all columns. If the level is again group level the application API returns data only for the grouped column & remaining column fields will be null at this level the application appends result set after expanded record index.

For more understanding, please share your email or mail to me @veerareddy.obula@gmail.com. I will schedule hangout / skype for detail walk through.