Hello Everyone, Greetings of the day! I am working on data grid 2 which is fetching data from a microflow and I have added date filter to the date column but the problem is whenever any of entry remains empty in the date column, date filters are not able to fetch the data instead Mendix throws error. I am attaching the log trace. Operator > not supported in expression >(, Fri Jul 15 2022 00:00:00 GMT+0530 (India Standard Time)) Error: Operator > not supported in expression >(, Fri Jul 15 2022 00:00:00 GMT+0530 (India Standard Time)) at > (http://localhost:8666/mxclientsystem/mxui/mxui.js?637934123404907958:68:64382) at >= (http://localhost:8666/mxclientsystem/mxui/mxui.js?637934123404907958:68:64453) at http://localhost:8666/mxclientsystem/mxui/mxui.js?637934123404907958:68:72365 at p (http://localhost:8666/mxclientsystem/mxui/mxui.js?637934123404907958:68:69547) at Object.evaluate (http://localhost:8666/mxclientsystem/mxui/mxui.js?637934123404907958:68:72033) at E (http://localhost:8666/mxclientsystem/mxui/mxui.js?637934123404907958:68:73307) at http://localhost:8666/mxclientsystem/mxui/mxui.js?637934123404907958:68:140940 at Array.map (<anonymous>) at http://localhost:8666/mxclientsystem/mxui/mxui.js?637934123404907958:68:140903 at http://localhost:8666/mxclientsystem/mxui/mxui.js?637934123404907958:68:140989 Any suggestions will be appreciated. Thank You
asked
Rajat Gupta
1 answers
0
Hi Rajat,
You have essentially answered your own question.
From the log it is clear that a comaprison is trying to be made with an empty object and hence the error. To avoid this try storing a generic date such as 9/9/9999 rather than storing empty dates.