ITAM: Filter is not accepting more than 100 criteria records
Article ID: 195457
Updated On:
Products
CA IT Asset Manager
CA IT Asset Manager Asset Portfolio Management
ASSET PORTFOLIO MGMT- SERVER
Issue/Introduction
In later releases of ITAM, the filters only allow up to 100 entries. Older releases allowed for more filter entries.
Cause
Design changes introduced into the product to improve performance. In releases 11.3.x and up until 14.x, filters functionality had caused performance issues that were addressed by limiting filter design to no more than 100 elements.
Environment
Release : 17.3
Component : CA Asset Portfolio Management
Resolution
Older releases of ITAM did allow additional filter entries per its design. As of 14.1, the filters are limited to 100 rows by design changes meant to improve overall performance.
Recommendation is to examine filter requirements to either:
- Detect for patterns which can be leveraged by other operators (ie using X LIKE 'ABC%' to create one filter entry instead of writing multiple discrete entries such as X = 'ABCD', X = 'ABCE', X = 'ABCF', etc.)
- Modifying the values themselves to create patterns that the filters can leverage. One example may be to modify the names of a given value with a prefix or suffix that the filter than then leverage (subject to site naming conventions).
Recommendation is to examine filter requirements to either:
- Detect for patterns which can be leveraged by other operators (ie using X LIKE 'ABC%' to create one filter entry instead of writing multiple discrete entries such as X = 'ABCD', X = 'ABCE', X = 'ABCF', etc.)
- Modifying the values themselves to create patterns that the filters can leverage. One example may be to modify the names of a given value with a prefix or suffix that the filter than then leverage (subject to site naming conventions).
Feedback
Powered by
