Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Unable to use wildcard characters in workbasket filter

SA-3103

Summary



Users would like the ability to use wildcard characters for filter keyword, such as *COR*;*CLC* (COR and CLC are case id prefixes) when they filter work ids in workbaskets. The functionality was working from 6.2 to 7.1.4. After upon migrating to 7.1.6, wildcard characters no longer works.

Error Messages



You observe an unexpected behavior where no result was returned after filtering.


Steps to Reproduce

  1. Go to workbasket/worklist
  2. Select filter on Case ID, in the editable field enter <%*ADM*;*CLC*%> any case id prefix in the following format.
  3. Click Enter.
  4. Observed no records were shown.
  5. Expected records whose case id has ADM or CLC to be listed.

Root Cause



This is an expected behavior of the filter functionality in PRPC. The usage of wildcard character is escaped to avoid SQL injection risk.


Resolution



The out of the box (ootb) filtering functionality does not allow customization on how the filtering is done. It is very specific in its function. This intended design is best addressed with custom search instead of using ootb filter.

Another suggestion is to create a new column of category which will allow your business user to choose case ids based on the category.
Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us