Suggestion on read only grid

Question

Consider a scenario where we have two entities: Books and Chapters, with a one-to-many relationship (i.e., each book can have multiple chapters). I currently have a read-only grid that displays records based on the Book entity. One of the columns in this grid is called "Chapters", which displays all associated chapters in a bulleted list. 
 
 Since a book can have more than 10 chapters, I'm currently fetching all chapters into a local variable and indexing them based on the Book ID to display in the corresponding grid row. 
 
 This approach works fine for now. However, I'm concerned about performance if the chapter count increases more than 5000 
 
 Does anyone have suggestions on how to handle this scenario more efficiently?

Stefan Helzle · Accepted Answer

So, it is about these child record, right? Did you consider to load them on demand? You could add a local variable to the individual cell, and load the data for this cell only when the user clicks the icon.

Varun Teja Gurrapu · Answer

Hi Barbosa ,

You can do it as osanchea to display in grid for a limited items.

It's not a best practice to show huge numbers of items in a single grid column, yes you can have n number of chapters per book, ultimately you cannot show it in a record list as a single column, instead you can show it in a new record view, eradicating difficulty of viewing such huge records.

You will have a space constraint blocking you to display multiple records: https://docs.appian.com/suite/help/25.1/sail/ux-grids.html#introduction (Check Don'ts).

Always check your grid view is intuitive and readable....

Hope this helps you!!!

Dai Williams · Answer

Try a tree view style component instead and see how that works, I have used this before for similar use cases ... 
 Tree View Component 
 You can also nest the data using Rich text as well.

Suggestion on read only grid

Top Replies