Question 4 Replies 79 Views × Close popover Madhusudan Sharma (MadhusudanS9253) EPAM Systems EPAM Systems IN View Profile Send Message MadhusudanS9253 Member since 2015 36 posts EPAM Systems Posted: July 18, 2019 Last activity: July 24, 2019 Posted: 18 Jul 2019 22:15 EDT Last activity: 24 Jul 2019 7:27 EDT Closed filter with Date in query runner is not working Hi, I am executing simple query in query runner landing page by filtering with dates. tried >,< and =. I am querying pc_work table. Results are not expected and it is ignoring date filter however in tracer I could see the query with write values. PFA screenshot. Thanks in advance. -Madhusudan Data Integration × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 1 year ago Posted: 19 Jul 2019 3:20 EDT × Close popover Srinivas Yoganarasimha (Srinivas21) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View Profile Send Message Srinivas21 PEGA replied to MadhusudanS9253 Hi Madhusudan, You have mentioned that the filter is not working as expected. Could you share what is the expected results from the filter operation? Posted: 1 year ago Posted: 21 Jul 2019 19:00 EDT × Close popover Madhusudan Sharma (MadhusudanS9253) EPAM Systems EPAM Systems IN View Profile Send Message MadhusudanS9253 EPAM Systems replied to MadhusudanS9253 Hi Srini, You can check my screen shot I have attached. I have provided two dates to filter but in the result I can see dates beyond filter criteria. Could you please check. Posted: 1 year ago Posted: 24 Jul 2019 7:16 EDT × Close popover Kevin Zheng (KevinZheng_GCS) PEGA Director, Software Solutions Engineering Pegasystems Inc. US View Profile Send Message KevinZheng_GCS PEGA replied to MadhusudanS9253 Mandhu, Have you confirmed the results from a native tool (like pgadmin4 for posgresql) that the exact same query yields different result? Posted: 1 year ago Posted: 24 Jul 2019 7:25 EDT × Close popover Madhusudan Sharma (MadhusudanS9253) EPAM Systems EPAM Systems IN View Profile Send Message MadhusudanS9253 EPAM Systems replied to KevinZheng_GCS Yes Kevin, I can see the correct result returned while executing from other tools.