SQL condition error

[Nader Garada]

Hi:

The Query works fine, but when add the condition like siteid=’BEDFORD’ I get error 500, Source  DoHttpCall

Internal Server Error

{“Error”:{“reasonCode”:null,”message”:”Lexical error at line 1, column 8.  Encountered: \”\\’\” (39), after : \”\””,”statusCode”:”500″}}

Please advise

This is Version Beta4

[Nader Garada]

I got it now, using ” instead of ‘

Thx for your time

 

[user]

When using REST service, you have to use oslc.where syntax.

See here: https://developer.ibm.com/static/site-id/155/maximodev/restguide/Maximo_Nextgen_REST_API.html#_filtering_data_using_where_clause

 

[Author]

Posts