Skip to main content
V
vaishals580434
April 4, 2025
Solved

Suggestion on read only grid

  • April 4, 2025
  • 9 replies
  • 0 views

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?

Best answer by stefanhelzle0001

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.

9 replies

O
orlandos8991
April 4, 2025

HI. If your record "book" has a one-to-many relationship with "chapters", you can try this to display it in a grid.

V
vaishals580434Author
April 5, 2025

Hi [mention:fb2e0435fccc4299a5d1c93da7622067:e9ed411860ed4f2ba0265705b8793d05] . Thanks for suggestion. But as i mentioned, books can have more than 10 chapters and this method limit related record to 10 items. 

    varuntejg243705
    varuntejg243705
    April 5, 2025

    Hi [mention:374f3c788d69451b95885af9933db781:e9ed411860ed4f2ba0265705b8793d05] ,

    You can do it as [mention:fb2e0435fccc4299a5d1c93da7622067:e9ed411860ed4f2ba0265705b8793d05]  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!!!

      stefanhelzle0001
      stefanhelzle0001
      April 5, 2025

      I think the purpose is the more important question. As a user of this application why would I navigate to this list? What do I want to achieve?

      V
      vaishals580434Author
      April 5, 2025

      Hi [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] . This is just a similar scenario I mentioned earlier. In my actual use case, the user will add multiple child records (possibly more than 10) while creating a new case. On the dashboard, we display a case grid, and the requirement is to show one of the related child records in a column of the case grid, along with an icon beside it to expand and view the full list of related records.

      stefanhelzle0001
      stefanhelzle0001Answer
      April 6, 2025

      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.

        Terms & ConditionsAccessibility statement