Create Gird Dynamically Report Definition Filter Issue
Hi,
We are generating a grid in a section with a source as Report Definition. Create grid dynamically option is selected. The report/grid has a column for pxUpdateDateTime. Filters are enabled. When selecting a check box for a specific date time on the filter for pxUpdateDateTime, Pega is returning 1 less record of the total count. When I run the resulting SQL in MS SQL or using RDB-List method, Pega is returning all the results. When I use the range filter, I get the correct total of results. Need help to understand if this is a known issue with product. I have attached the screen shots and the corresponding SQL
SELECT "PC0"."pyGUID" AS "pyGUID" ,"PC0"."pxUpdateDateTime" AS "pxUpdateDateTime" , "PC0"."pxCreateOpName" AS "pxCreateOpName" , "PC0"."pxCreateDateTime" AS "pxCreateDateTime" FROM ************ "PC0" WHERE ( ( "PC0"."Status" IN ('Active' ,'Canceled' , 'Future Active' , 'In Progress' , 'Never Active' , 'Past Active' ) ) AND ( "PC0"."pxUpdateDateTime" BETWEEN '2022-08-09 17:15:31.907' AND '2022-08-09 17:15:32.906' OR "PC0"."pxUpdateDateTime" BETWEEN '2022-08-09 17:15:31.357' AND '2022-08-09 17:15:32.356' OR "PC0"."pxUpdateDateTime" BETWEEN '2022-08-09 17:15:31.863' AND '2022-08-09 17:15:32.862' ) ) ORDER BY 72 DESC;