Project and Portfolio Management Practitioners Forum
cancel

Query Builder Issue

Highlighted
Bharath_Kumar
Respected Contributor.

Query Builder Issue

Hi Team,

 

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.

 

 

2 REPLIES
Niraj Prabhu
Outstanding Contributor.

Re: Query Builder Issue

Bharath,

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.
Niraj P.
Bharath_Kumar
Respected Contributor.

Re: Query Builder Issue

Actually this being an OOB functionality , we will not be able to give the to_number conversion while specifying some condition.

 

Please let me know if my understanding is right or not.