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.
Steps to Reproduce
1.Run a report definition
2.Perform filtering on the .pxcreateDateTime property
The SQL SERVER 2016 database with sqljdbc6 jar for the JDBC connection was present.
Perform the following local-change:
Use sqljdbc4 jar
0% found this useful