This topic is locked

Advanced Search Less Than

5/9/2012 7:05:58 AM
PHPRunner General questions
W
weisd author

When using Advanced Search, I enter "Less Than" and the number 226 expecting to return records between 0 and 225.
However, I get records larger than 226. For example, 2259 is returned...
As a matter of fact, 1314 records are returned when there should only be 225 records that meet the criteria.
Is this fixable?
Thanks
PZ

hfg 5/9/2012

Which version of PHPR are you using. I have had some odd issues with 6.1 on projects that were upgraded. I have had to go back and check the search settings in PHPR sometimes un-checking and rechecking the option for the field(s) that are causing issues. I then reset the search and list page just to be safe. So far that has fixed most of my issues.



When using Advanced Search, I enter "Less Than" and the number 226 expecting to return records between 0 and 225.
However, I get records larger than 226. For example, 2259 is returned...
As a matter of fact, 1314 records are returned when there should only be 225 records that meet the criteria.
Is this fixable?
Thanks
PZ

W
weisd author 5/9/2012



Which version of PHPR are you using. I have had some odd issues with 6.1 on projects that were upgraded. I have had to go back and check the search settings in PHPR sometimes un-checking and rechecking the option for the field(s) that are causing issues. I then reset the search and list page just to be safe. So far that has fixed most of my issues.


6.1
However the problem is that the datatype is set to text...

Sergey Kornilov admin 5/9/2012

Most likely this field is setup as a text field in the database. Make sure this field is setup as number and your search will work as expected.