Hello, I'm trying to use the _uw property in a REST query with maximo 7.5
This should allow to specify a SQL WHERE clause to be used as the selection criteria
But I'm not able to have it working. Note that I've noticed that the mxe.rest.whereclause.usepolicy system property was not defined in my system, so I've created it with the "parse" value.
I'm trying first with a simple query like:
I've tried many syntax variants but unsuccesfully.
Obviously the objective is to use more complex sql query and also to use stored query (e.g. SQL WHERE clause stored with a work schedule in the Scheduler application)
any help would be very much appreciated
This topic has been locked.
4 replies Latest Post - 2012-08-07T18:22:36Z by TomSarasin
Pinned topic REST API and
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-08-07T18:22:36Z at 2012-08-07T18:22:36Z by TomSarasin
Re: REST API and2012-02-09T13:08:43Z in response to StephaneMichelTry removing the double quotes around the query parameters. I was able to do similar
query where only the wo number was in single quotes.
SpikeBarefield 270002BSAC1 PostACCEPTED ANSWER
Re: REST API and2012-08-06T20:55:33Z in response to TomSarasinWe also were not able to get the REST API Query Parameter (_uw) to work.
We are on maximo 188.8.131.52 and we have also created a System Property (mxe.rest.whereclause.usepolicy) and set its value to "parse". It appears that when we use this configuration, the where clause is ignored.
1) Do we need a more recent version of Maximo than 184.108.40.206?
2) Is there something else that needs to be configured?
3) Do you have any examples you could share that do work?
The other query functionality of the REST API seesm to work, but not the "_uw".
Re: REST API and2012-08-07T18:22:36Z in response to StephaneMichelTry using this
no need to provide quotes around user/pw but you do need single
quote around the 7300 in the where clause