Support Article
Filter functionality does not work for pxCreateDateTime field
SA-67305
Summary
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.
Resolution
Perform the following local-change:
Use sqljdbc4 jar
Published May 1, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.