minor updates to the _readWithScan and added test cases for all conditions: equal, not equal, less than, less than or equal to, greater than, greater than or equal to, null, not null, contains, doesnt contains, begins with, in, between