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
Re: REST API and2012-02-09T13:08:43ZThis is the accepted answer. This is the accepted answer.Try 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 Post
Re: REST API and2012-08-06T20:55:33ZThis is the accepted answer. This is the accepted answer.
- TomSarasin 0600024UY2
We are on maximo 22.214.171.124 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 126.96.36.199?
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:36ZThis is the accepted answer. This is the accepted answer.Try using this
no need to provide quotes around user/pw but you do need single
quote around the 7300 in the where clause