MxLoader

View Only

Back to discussions

oslc.where return unexpected result

1. oslc.where return unexpected result

Like
alan lai
Posted 01-13-2023 09:15
| view attached

Reply Reply Privately
I tried to use oslc api to retrieve workorder data, my goal is to list latest 10 CM workorder that status is CLOSE or COMP. I got same error in production environment, so I use demo data for testing.
postman input "GET"

http://192.168.0.166:9080/maximo/oslc/os/mxwo?oslc.select=wonum,assetnum,location,worktype,reportdate,status&olsc.where=worktype="CM" and status in ["CLOSE","COMP"]&oslc.orderby=-reportdate&_lid=wilson&_lpwd=wilson&oslc.paging=true&oslc.pageSize=10

response is as below shown, you can find some workorder worktype is EM, PM not only CM, status is all mixed, reportdate is not in result. May I have your help?

------------------------------
alan lai
mropro
------------------------------

Attachment(s)

postman-response-mxwo-10CM.txt 4 KB 1 version

Newest Episode

Ep. 5 | Make Manage Feel Like Home with Configuration, Not Customization

Watch Steven Shull and Phil Runion discuss how IBM Maximo Manage teams can make the system feel more familiar, useful, and aligned to their business through configuration instead of customization.

Watch on YouTube Listen on Spotify