MxLoader

 View Only

oslc.where return unexpected result

  • 1.  oslc.where return unexpected result

    Posted 01-13-2023 09:15
      |   view attached
    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)



Newest Episode
Ep. 10 | How Naviam DataStudio Makes Data Imports Easier with Lee Daley

Steven Shull and Lee Daley explore how Naviam DataStudio helps IBM Maximo teams simplify bulk data imports, validate information before loading, and improve data quality and management.

MORE by Naviam Episode 10: How Naviam DataStudio Makes Data Imports Easier with Lee Daley
Watch Episode 10
Also available: Ep. 9 | Best Maximo Resources to Stay Informed