Applicable Product:

• Talent Management: All Products

Applicable Release:

• V21+

Summary:

In certain scenarios, applying sorting to a grid can lead to performance degradation. To resolve this, sorting must be removed from the associated System Grid View (Public), User Grid View (Private), or directly from the List Grid if no view is associated.

This article outlines the steps to remove sorting from each of these grid types.

System Grid Views (Public)

Purpose

Remove sorting from a public grid view to improve performance.

Steps

1. Log in as an Administrator.
2. Navigate to:
   Main Menu > Reporting > Grid Reporting
3. Filter by the relevant grid category.
4. Click on the View Name.
5. From the toolbar, click Select View > Manage Views.
6. Note the View ID and View Name.
7. Navigate to:
   Site Configuration > Data Tools > System Grid Views
8. Filter the ID and Name columns using the values obtained.
9. Click the Remove Sorting icon.

User Grid Views (Private)

Purpose

Remove sorting from a private user grid view.

Steps

1. Log in as an Administrator.
2. Navigate to:
   Main Menu > Turn Design Mode On
3. Go to:
   Main Menu > Reporting > Grid Reporting
4. Filter by the relevant grid category (e.g., Bonus History).
5. Click the Edit In Place icon for the private view (e.g., By Currency Code).
6. Identify the View ID (after the underscore) and View Name.
7. Navigate to:
   Site Configuration > Data Tools > User Grid Views
8. Filter the ID and Name columns using the values obtained.
9. Click the Remove Sorting icon.

List Grids

Purpose

Remove sorting from list grids that do not have associated views.

Steps

1. Navigate to:
   Main Menu > Turn Design Mode On
2. Go to the relevant list grid (e.g., Inclusions under Performance Management Plan > Eligibility).
3. Click the Configure Columns button in the toolbar.
4. In Selected Display Columns, select the column with sorting (e.g., Name) and click Remove.
5. In Available Columns, select a different column and click Add.
6. Click Save.
7. Click the newly added column to apply sorting.
8. Reopen Configure Columns, remove the temporary column, and re-add the original column (e.g., Name).
9. Save the changes. The grid will now have no sorting applied.

Additional Notes

• Removing sorting can significantly improve grid load times.
• Always ensure you have the correct View ID and View Name before making changes.
• Design Mode must be enabled to access certain configuration options.