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.
Release : 17.3
Component : CA Asset Portfolio Management
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).