MxLoader

 View Only
Back to discussions
Expand all | Collapse all

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)

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


Related Content