Question4Replies70Views MadhusudanS9253 Member since 2015 32 posts Ness Technologies Posted: July 18, 2019Last activity: July 24, 2019 Closed filter with Date in query runner is not workingHi,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 popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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 agoSrinivas21 PEGA replied to MadhusudanS9253Hi 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 agoMadhusudanS9253 Ness Technologies replied to MadhusudanS9253Hi 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 agoKevinZheng_GCS PEGA replied to MadhusudanS9253Mandhu, Have you confirmed the results from a native tool (like pgadmin4 for posgresql) that the exact same query yields different result? Posted: 1 year agoMadhusudanS9253 Ness Technologies replied to KevinZheng_GCSYes Kevin, I can see the correct result returned while executing from other tools.