You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

null or '' value filter on SDP table

edited Aug 13, 2019 8:48PM in Visual Builder 1 comment

Content

Say, we have 'Name','EmpID','CIty', 'State' columns in a SDP table.

filter/search input fields on the table are State, Name and EmpID. filter criterion operator on EmpID is set as '$eq'.

I have few records where EmpID value is null. when I try to retrieve these records using my search criterion on the table. I am unable to do so. I get 'No data to display' as my result. 

my REST query on network tab is sent as EMP ID = 'NULL' OR 'EMP ID' =' ' ' '

$pr operator ignores these records before table display.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!