Selectively Load Process Status Formatter Based on Status

Introduction

When dealing with large datasets in a List, displaying numerous records on a single page can overwhelm the browser, leading to slow loading times. This article addresses a common performance issue where displaying 100 or more records results in multiple server calls, causing the Process Status Bar to load slowly. We will explore a workaround using the Multi Datalist Formatter plugin and BeanShell code to improve performance by selectively loading the status bar only for specific records.

How does it work?

1. In the List Builder, for the status column, set the Formatter to Multi Datalist Formatter. Then, configure the first formatter within it as a BeanShell Formatter.
   
2. Add the following BeanShell code to display the Process Status Bar only for records marked as Resolved or Assigned.
   

   String status = row.get("status");
   if(status.equals("Resolved")||status.equals("Assigned")){
   return value; //this is PID to pass to second formatter
   }else{
   return null; //If null then process status wont load
   }

   

3. Next, set the Choose The Second Datalist Formatter to Process Status.
   
4. Apply the changes and save the list.

Expected Outcome

After implementing this approach, the List will load more efficiently even when handling large datasets. The Process Status Bar will only be rendered for records with the status Resolved or Assigned, while it will not be loaded for other records. This reduces unnecessary server calls, resulting in improved page performance and a faster, smoother user experience when viewing the List.

Download demo app