Hi All,
I have scenario where i am using a query entity,
in this i have a date and time field. out of which the values of the 2 rows present are value of Now() and null
When i am trying to filter them like
a!queryFilter(
field:"date",
operator:"is null"
)
it is not differentiating the results and it is giving me the entire set.
Am I going wrong anywhere on this,
TIA:)
Harsha
Discussion posts and replies are publicly visible
Hi harsha, You are getting entire set means that filter is not applying, because if that filter works then you should get the result where filed "date" is null or if their is no null values then you should get empty result but you are getting entire set. may be your filter has conditions that when it has to apply check that once.Make sure that your value in db is null not empty