The In-Memory technology makes it possible to filter and sort Task Lists with over 10,000 items. As an example, if a user has 100,000 products in a workflow state and wants to filter for all the items that do not have a certain value, the filtering happens across the entire set of 100,000 items and not only the 10,000 that are available in the Task List.
These settings are global for the server, which means that the settings will be enabled for all Task List screens across all Web UIs.
To enable this functionality, the following properties need to be added to the sharedconfig.properties file:
- TaskList.Streaming.Enabled=true
This enables the streaming filtering / sorting functionality.
- TaskList.Streaming.MaxResults=100000
This sets the max number of items in the workflow being streamed / filtered. For example, if there are 150,000 items, only the first 100,000 will be filtered / sorted. This number can be increased, but performance issues may occur the larger the number gets.
- Portal.TaskList.Max=100000
This sets the upper limit for the number of items that will show in the Task List.
Important: Since increasing the number of objects that are displayed in the Task List can negatively impact performance, thorough testing is recommended on lower environments before applying a new limit to production.
For Task List configuration information, refer to the Task List topic in the Web User Interfaces documentation.
Considerations and Limitations
Only some column types are supported for sorting / filtering, when the set of data grows larger than the maximum set in the Portal.TaskList.Max property.
The following column types are supported:
- Supplier Header
- ID header
- Name Header
- Title Header
- Attribute Value / Attribute Value Group Header, where the value is NOT:
- Multi Valued
- Calculated / Contains Inline References
And the following views on the task list:
- Compare Display Mode
- Multi Edit Display Mode
- Table Display Mode