I'm facing a strange issue.
I have put a checkbox in the search Change page. The name in the dbdict is change.flag and i have mentioned the same in fd as well.
Now when I open the Change search page and Click search, it displays a list of records. When I click on above check box and search it say no records found. Now the problem is I uncheck the same checkbox and click search again, then it says no records found !!!! which is incorrect. When I checked in the expert search I could see the below query
true and middle,change.flag#false
above query looks fine to me, but it doesn't fetch any records
1. Please can any1 tell me why this is happening? ( is it coz there are no records in the dB for this field, which means the value is NULL and when true/false value is searched against NULL it yields this result?)
2. Is there any way to clear only the change.flag when unchecked?