I am trying to run a query for which we are getting date as a null value and due to which the query is not getting executed . For Example : SELECT HIRE_DATE AS HIREDATE, COMPANYNAME AS COMPANY FROM DIRECTORY WHERE NAME = 'XYZ' AND GENDER = 'MALE' Here for few of the data the Hire date is coming null for some reason due to which the query is not getting executed. Could anyone help in how to use NVL function in Mendix.
asked
Pulak Jain
1 answers
1
Hey your query doesn't look correct. You need to use module name and entity name in the query.