How to filter negative values from readonly grid

Please share the actual code you've tried so we can make informed comments.  Generally an a!queryFilter(), when filtering on a numeric value, should accept the "<" operator just fine, but any number of other things could have gone wrong before it even gets that far, and it's hard to guess without seeing exactly what you've tried and exactly what went wrong.

are you trying to filter values which does not match a condition. Example :- Filter values which are not equals to 1 or "ABC", if so then using <>  operator might works for you.

Also you can use Appian query editor on top side of expression rule for guided development for writing these type of query.

Please ignore the field, I have used (-) in contact number just for testing purpose and here is the result. Maybe it will be helpful for you.

For testing purpose I used the some value and here is the result. Maybe it will be helpful for you.

hi mike thankyou for responding

my requirement is I have to make a filter for latitude and longitude as latitude from latitude to and longitude from longitude to when user put some values in latitude from and latitude to then it filters the values between those values from grid

for reference : 

here i wan values above 42 as well like 42.2 but just getting values between 41 and 42
if there is any solution please let me know

if you want a value like 42.2 to be included then your "to" filter entry should be 43.  Or you could just override the filter value and add 1 to whatever the user enters, so it would match all values up to the next higher integer (you'd just need to test it well to make sure different corner cases work like you expect).

thankyou for responding

hi mike thankyou for responding

my requirement is I have to make a filter for latitude and longitude as latitude from latitude to and longitude from longitude to when user put some values in latitude from and latitude to then it filters the values between those values from grid

for reference : 

here i want values above 42 as well like 42.2 but just getting values between 41 and 42
if there is any solution please let me know

thankyou prasanta for responding 

hi mike thankyou for responding

my requirement is I have to make a filter for latitude and longitude as latitude from latitude to and longitude from longitude to when user put some values in latitude from and latitude to then it filters the values between those values from grid

for reference : 

here i want values above 42 as well like 42.2 but just getting values between 41 and 42
if there is any solution please let me know

but the requirement is that user can enter any value like 41 and 42 but grid should give values till 42.99 .

is it possible to make chnages in expression rule so that if user puts 41 and 42 then grid could give values like 42.5 or something like that?

user should be sorted in his mind if he enters value 41 and  42 then any value around 42 will be populated like 42.2 or 42.4 etc

appian.user said:

but the requirement is that user can enter any value like 41 and 42 but grid should give values till 42.99

ok, and that's why i said this:

Mike Schmitt said:

Or you could just override the filter value and add 1 to whatever the user enters, so it would match all values up to the next higher integer

Did you try that already?