Maksim Khalikov (MaksimK7)
Alfa Bank

Alfa Bank
MaksimK7 Member since 2019 1 post
Alfa Bank
Posted: March 31, 2021
Last activity: April 14, 2021
Posted: 31 Mar 2021 12:48 EDT
Last activity: 14 Apr 2021 9:30 EDT

Milliseconds are ignored while sorting Report Definiton by pxCreateDateTime

Hi! I use Report Definition to retrieve data from Oracle DB with filter pxCreateDateTime greater or equal 20010101T162051.111 GMT. But the RD shows rows starting from 20010101T162051.000 GMT. And when I'm trying to retrive an exact row with filter criteria pxCreateDateTime is equal 20010101T162051.111 GMT it shows the rows within one second intrval. Has anyone faced this situation before? How can it be solved?

***Edited by Moderator Marissa to update Platform Capability tags****
Pega Platform 8.3.1 Reporting