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

Filter functionality does not work for pxCreateDateTime field



User has a report definition with multiple columns on which the list of cases display. User enables the Filter and Sort options for each column. The filter functionality does not work for the pxCreateDateTime field column for a few stretched record values. However, the same record is fetched on performing the filter on a different column. The SQL query generated for working and non-working scenarios are similar. Running the query generated on clicking the filter in the data base fetches the record.

Error Messages

Not Applicable

Steps to Reproduce

1.Run a report definition
2.Perform filtering on the .pxcreateDateTime property

Root Cause

The SQL SERVER 2016 database with sqljdbc6 jar for the JDBC connection was present.


Perform the following local-change: 
Use sqljdbc4 jar



Published May 1, 2019 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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