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 20,000 products in a workflow state and wants to filter for all the items that does not have a certain value, the filtering happens among the entire set of 20,000 items and not only the 10,000 that are available in the Task List.
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=10000
This sets the upper limit for the number of items that will show in the Task List. 10,000 is the maximum value.
It is important to be aware that these settings are global for the server. This means that the settings will be enabled for all Task List screens across all Web UIs.
For Task List configuration information, refer to the Task List topic in the Workflows in Web UI documentation here.
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