We are currently using HP PPM 7.5 SP7 and soon we are upgrading to PPM 9.1.
We are now facing issue with the Query Builder, wherein we specify a field 'A1' > 1000. A1 being the field in a request type with validation to hold only Numeric Values. However, the query is returning rows which are having 'A1' values which are either = 1000 or < 1000.
Please let us know on how this criteria in Query Builder works normally.
Can you check if the field A1 storage is using the Max Length 4000, inspite of having numeric validation? For field storage 4000, this seems to have shown error in my previous testing. May be similar issue is at your end. Try building sql query and execute to see, if the criteria > 1000 returns correctly.
I suspect if database stored it differently. Since it is a numeric field, try to_number as well. One of this should provide you some hint.