Retrieve PRM Work Items By Code
    • 25 Sep 2024
    • 6 Minutes to read
    • Dark
      Light

    Retrieve PRM Work Items By Code

    • Dark
      Light

    Article summary

    Get
    /prm-rest-api/rest/1/prmworkitem

    Query Standards

    Finder

    Following row finders are available for data filtering and optimizing request performance.

    • Select By Date
    • By UUID

    Select By Date

    Recommended finder parameters. Refer to Query Parameters for example.

    ParameterDescriptionSample
    auditDateCreate or Update Date Time Filter2015-06-01

    By UUID

    This is an optional finder for querying a specific PRM Work Item by row ID.

    ParameterDescriptionSample
    /VUUIDThe VUuid attribute is the Unique row ID/prm-rest-api/rest/1/prmworkitem/D21729F91C7B5FB8E05316821FACAF93
    Security
    HTTP
    Type basic

    Basic authentication

    Query parameters
    finder
    string
    ExampleselectByDate; auditDate=2015-06-01
    limit
    integer
    Example500
    offset
    integer
    Example0
    totalResults
    boolean
    Exampletrue
    orderBy
    string
    ExampleWitmVUuid:desc
    Responses
    200

    OK

    Headers
    Content-Type
    string
    Exampleapplication/vnd.oracle.adf.resourcecollection+json
    {
      "items": [
        {
          "WitmWorkItemType": "JB",
          "WitmTaskCode": null,
          "WitmTaskPtgtType": null,
          "WitmTgtType": "JB",
          "WitmWoCompCode": "001",
          "WitmWoCode": "WO.8",
          "WitmLineNumber": 1,
          "WitmWoStepTitle": "Repairing Drywall",
          "WitmWoStepDescription": "Repairing Drywall",
          "WitmDeadlineDate": "2015-09-15",
          "WitmThresholdDate": "2015-09-15",
          "WitmRecurringFlag": "0",
          "WitmDeadlineReading": null,
          "WitmMissedTaskCount": 0,
          "WitmAcumTypeCode": null,
          "WitmJcatLabCompCode": null,
          "WitmJcatLabJobCode": null,
          "WitmJcatLabPhsCode": null,
          "WitmJcatLabourCode": null,
          "WitmJcatPartsCompCode": null,
          "WitmJcatPartsJobCode": null,
          "WitmJcatPartsPhsCode": null,
          "WitmJcatPartsCode": null,
          "WitmJcatConCompCode": null,
          "WitmJcatConJobCode": null,
          "WitmJcatConPhsCode": null,
          "WitmJcatContractorCode": null,
          "WitmJcatEqCompCode": null,
          "WitmJcatEqJobCode": null,
          "WitmJcatEqPhsCode": null,
          "WitmJcatEquipmentCode": null,
          "WitmJcatOthCompCode": null,
          "WitmJcatOthJobCode": null,
          "WitmJcatOthPhsCode": null,
          "WitmJcatOtherCode": null,
          "WitmWiccCompCode": null,
          "WitmWiccLabourCode": null,
          "WitmWiccPartsCode": null,
          "WitmWiccContractorCode": null,
          "WitmWiccEquipmentCode": null,
          "WitmWiccOtherCode": null,
          "WitmStatus": "O",
          "WitmComments": null,
          "WitmCompletionDate": null,
          "WitmCompletionReading": null,
          "WitmNoticePrtCnt": null,
          "WitmClass1": null,
          "WitmClass2": null,
          "WitmClass3": null,
          "WitmClass4": null,
          "WitmVendorCode": null,
          "WitmScheduleDate": "2015-09-10",
          "WitmActiveFlag": null,
          "WitmTeamCode": null,
          "WitmBchNum": null,
          "WitmPostDate": null,
          "WitmSrcCompCode": "001",
          "WitmJobCode": "WO.8",
          "WitmPhsCode": "1",
          "WitmDeptCode": "080",
          "WitmPriority": 1,
          "WitmIssueId": null,
          "WitmDeliveryDate": null,
          "WitmAppTypeCode": "CRM",
          "WitmDateCreated": null,
          "WitmCreatedBy": null,
          "WitmDateModified": null,
          "WitmModifiedBy": null,
          "WitmScheduleEndDate": null,
          "WitmBillingType": "T",
          "WitmSubmittedBillingFlag": null,
          "WitmBillingAmt": null,
          "WitmBillingStateCode": "NR",
          "WitmChargeJobFlag": null,
          "WitmChargeCompCode": null,
          "WitmChargeJobCode": null,
          "WitmChargePhsCode": null,
          "WitmChargeCatCode": null,
          "WitmUnits": null,
          "WitmWoEntry2Flag": "N",
          "WitmBuildingCode": "101",
          "WitmFloorNo": "01",
          "WitmRoomNo": "101",
          "WitmUserField2": "WO.8",
          "WitmUserField3": "1",
          "WitmSelectFlag": "N",
          "WitmWoVUuid": "D21723A19CE15650E05316821FACB6B7",
          "WitmVUuid": "D21729F91C7B5FB8E05316821FACAF93",
          "WitmIuCreateDate": "2015-09-09T08:55:23Z",
          "WitmIuCreateUser": "ADWAIT",
          "WitmIuUpdateDate": null,
          "WitmIuUpdateUser": null,
          "links": [
            {
              "rel": "self",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C7B5FB8E05316821FACAF93",
              "name": "prmworkitem",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C7B5FB8E05316821FACAF93",
              "name": "prmworkitem",
              "kind": "item"
            }
          ]
        },
        {
          "WitmWorkItemType": "JB",
          "WitmTaskCode": null,
          "WitmTaskPtgtType": null,
          "WitmTgtType": "JB",
          "WitmWoCompCode": "001",
          "WitmWoCode": "WO.00004",
          "WitmLineNumber": 1,
          "WitmWoStepTitle": "Damaged Drywall",
          "WitmWoStepDescription": "Damaged Drywall needs to be replaced because of water damage",
          "WitmDeadlineDate": "2015-07-21",
          "WitmThresholdDate": "2015-07-21",
          "WitmRecurringFlag": "0",
          "WitmDeadlineReading": null,
          "WitmMissedTaskCount": 0,
          "WitmAcumTypeCode": null,
          "WitmJcatLabCompCode": null,
          "WitmJcatLabJobCode": null,
          "WitmJcatLabPhsCode": null,
          "WitmJcatLabourCode": null,
          "WitmJcatPartsCompCode": null,
          "WitmJcatPartsJobCode": null,
          "WitmJcatPartsPhsCode": null,
          "WitmJcatPartsCode": null,
          "WitmJcatConCompCode": null,
          "WitmJcatConJobCode": null,
          "WitmJcatConPhsCode": null,
          "WitmJcatContractorCode": null,
          "WitmJcatEqCompCode": null,
          "WitmJcatEqJobCode": null,
          "WitmJcatEqPhsCode": null,
          "WitmJcatEquipmentCode": null,
          "WitmJcatOthCompCode": null,
          "WitmJcatOthJobCode": null,
          "WitmJcatOthPhsCode": null,
          "WitmJcatOtherCode": null,
          "WitmWiccCompCode": null,
          "WitmWiccLabourCode": null,
          "WitmWiccPartsCode": null,
          "WitmWiccContractorCode": null,
          "WitmWiccEquipmentCode": null,
          "WitmWiccOtherCode": null,
          "WitmStatus": "O",
          "WitmComments": null,
          "WitmCompletionDate": null,
          "WitmCompletionReading": null,
          "WitmNoticePrtCnt": null,
          "WitmClass1": null,
          "WitmClass2": null,
          "WitmClass3": null,
          "WitmClass4": null,
          "WitmVendorCode": null,
          "WitmScheduleDate": "2015-07-13",
          "WitmActiveFlag": null,
          "WitmTeamCode": null,
          "WitmBchNum": null,
          "WitmPostDate": null,
          "WitmSrcCompCode": "001",
          "WitmJobCode": "WO.00004",
          "WitmPhsCode": null,
          "WitmDeptCode": "080",
          "WitmPriority": 2,
          "WitmIssueId": null,
          "WitmDeliveryDate": null,
          "WitmAppTypeCode": "CRM",
          "WitmDateCreated": null,
          "WitmCreatedBy": null,
          "WitmDateModified": null,
          "WitmModifiedBy": null,
          "WitmScheduleEndDate": null,
          "WitmBillingType": "T",
          "WitmSubmittedBillingFlag": null,
          "WitmBillingAmt": null,
          "WitmBillingStateCode": "NR",
          "WitmChargeJobFlag": null,
          "WitmChargeCompCode": null,
          "WitmChargeJobCode": null,
          "WitmChargePhsCode": null,
          "WitmChargeCatCode": null,
          "WitmUnits": null,
          "WitmWoEntry2Flag": "N",
          "WitmBuildingCode": null,
          "WitmFloorNo": null,
          "WitmRoomNo": null,
          "WitmUserField2": "WO.00004",
          "WitmUserField3": null,
          "WitmSelectFlag": "N",
          "WitmWoVUuid": "D21723A19CE05650E05316821FACB6B7",
          "WitmVUuid": "D21729F91C7A5FB8E05316821FACAF93",
          "WitmIuCreateDate": "2015-07-09T01:26:43Z",
          "WitmIuCreateUser": "ADWAIT",
          "WitmIuUpdateDate": null,
          "WitmIuUpdateUser": null,
          "links": [
            {
              "rel": "self",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C7A5FB8E05316821FACAF93",
              "name": "prmworkitem",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C7A5FB8E05316821FACAF93",
              "name": "prmworkitem",
              "kind": "item"
            }
          ]
        },
        {
          "WitmWorkItemType": "JB",
          "WitmTaskCode": null,
          "WitmTaskPtgtType": null,
          "WitmTgtType": "JB",
          "WitmWoCompCode": "001",
          "WitmWoCode": "WO.00003",
          "WitmLineNumber": 1,
          "WitmWoStepTitle": "Fixture of Window",
          "WitmWoStepDescription": "Fixture of Window",
          "WitmDeadlineDate": "2015-06-11",
          "WitmThresholdDate": "2015-06-11",
          "WitmRecurringFlag": "0",
          "WitmDeadlineReading": null,
          "WitmMissedTaskCount": 0,
          "WitmAcumTypeCode": null,
          "WitmJcatLabCompCode": null,
          "WitmJcatLabJobCode": null,
          "WitmJcatLabPhsCode": null,
          "WitmJcatLabourCode": null,
          "WitmJcatPartsCompCode": null,
          "WitmJcatPartsJobCode": null,
          "WitmJcatPartsPhsCode": null,
          "WitmJcatPartsCode": null,
          "WitmJcatConCompCode": null,
          "WitmJcatConJobCode": null,
          "WitmJcatConPhsCode": null,
          "WitmJcatContractorCode": null,
          "WitmJcatEqCompCode": null,
          "WitmJcatEqJobCode": null,
          "WitmJcatEqPhsCode": null,
          "WitmJcatEquipmentCode": null,
          "WitmJcatOthCompCode": null,
          "WitmJcatOthJobCode": null,
          "WitmJcatOthPhsCode": null,
          "WitmJcatOtherCode": null,
          "WitmWiccCompCode": null,
          "WitmWiccLabourCode": null,
          "WitmWiccPartsCode": null,
          "WitmWiccContractorCode": null,
          "WitmWiccEquipmentCode": null,
          "WitmWiccOtherCode": null,
          "WitmStatus": "O",
          "WitmComments": null,
          "WitmCompletionDate": null,
          "WitmCompletionReading": null,
          "WitmNoticePrtCnt": null,
          "WitmClass1": null,
          "WitmClass2": null,
          "WitmClass3": null,
          "WitmClass4": null,
          "WitmVendorCode": null,
          "WitmScheduleDate": "2015-06-08",
          "WitmActiveFlag": null,
          "WitmTeamCode": null,
          "WitmBchNum": null,
          "WitmPostDate": null,
          "WitmSrcCompCode": "001",
          "WitmJobCode": "WO.00003",
          "WitmPhsCode": null,
          "WitmDeptCode": "050",
          "WitmPriority": 2,
          "WitmIssueId": null,
          "WitmDeliveryDate": null,
          "WitmAppTypeCode": "CRM",
          "WitmDateCreated": null,
          "WitmCreatedBy": null,
          "WitmDateModified": "2015-08-30T11:27:00Z",
          "WitmModifiedBy": "BILL",
          "WitmScheduleEndDate": "2015-06-09",
          "WitmBillingType": "T",
          "WitmSubmittedBillingFlag": null,
          "WitmBillingAmt": 400,
          "WitmBillingStateCode": "SB",
          "WitmChargeJobFlag": null,
          "WitmChargeCompCode": null,
          "WitmChargeJobCode": null,
          "WitmChargePhsCode": null,
          "WitmChargeCatCode": null,
          "WitmUnits": null,
          "WitmWoEntry2Flag": "N",
          "WitmBuildingCode": "101",
          "WitmFloorNo": "01",
          "WitmRoomNo": "103",
          "WitmUserField2": "WO.00003",
          "WitmUserField3": null,
          "WitmSelectFlag": "N",
          "WitmWoVUuid": "D21723A19CF35650E05316821FACB6B7",
          "WitmVUuid": "D21729F91C845FB8E05316821FACAF93",
          "WitmIuCreateDate": "2015-06-04T05:39:58Z",
          "WitmIuCreateUser": "ADWAIT",
          "WitmIuUpdateDate": "2015-08-30T11:27:00Z",
          "WitmIuUpdateUser": "BILL",
          "links": [
            {
              "rel": "self",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C845FB8E05316821FACAF93",
              "name": "prmworkitem",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C845FB8E05316821FACAF93",
              "name": "prmworkitem",
              "kind": "item"
            }
          ]
        },
        {
          "WitmWorkItemType": "EQ",
          "WitmTaskCode": "01",
          "WitmTaskPtgtType": "CL",
          "WitmTgtType": "EQ",
          "WitmWoCompCode": "001",
          "WitmWoCode": "PWOYY.002",
          "WitmLineNumber": 2,
          "WitmWoStepTitle": "A 250 Hr Service",
          "WitmWoStepDescription": "CHG ENG OIL            GALS    15W40      BLUE       3.5 GAL           SAE 15W40             BLUE             3.5 GAL           INSPECT FOR LEAKS WHEN COMPLETED           REMOVE CRANKCASE VENT TUBE & CLEAN, REINSTALLCHG ENG OIL FILTER          J.D. RE504836 OR NAPA 7750S",
          "WitmDeadlineDate": "2015-05-27",
          "WitmThresholdDate": "2015-05-27",
          "WitmRecurringFlag": "1",
          "WitmDeadlineReading": null,
          "WitmMissedTaskCount": 0,
          "WitmAcumTypeCode": "CD",
          "WitmJcatLabCompCode": null,
          "WitmJcatLabJobCode": null,
          "WitmJcatLabPhsCode": null,
          "WitmJcatLabourCode": null,
          "WitmJcatPartsCompCode": null,
          "WitmJcatPartsJobCode": null,
          "WitmJcatPartsPhsCode": null,
          "WitmJcatPartsCode": null,
          "WitmJcatConCompCode": null,
          "WitmJcatConJobCode": null,
          "WitmJcatConPhsCode": null,
          "WitmJcatContractorCode": null,
          "WitmJcatEqCompCode": null,
          "WitmJcatEqJobCode": null,
          "WitmJcatEqPhsCode": null,
          "WitmJcatEquipmentCode": null,
          "WitmJcatOthCompCode": null,
          "WitmJcatOthJobCode": null,
          "WitmJcatOthPhsCode": null,
          "WitmJcatOtherCode": null,
          "WitmWiccCompCode": null,
          "WitmWiccLabourCode": null,
          "WitmWiccPartsCode": null,
          "WitmWiccContractorCode": null,
          "WitmWiccEquipmentCode": null,
          "WitmWiccOtherCode": null,
          "WitmStatus": "C",
          "WitmComments": null,
          "WitmCompletionDate": "2016-03-09",
          "WitmCompletionReading": null,
          "WitmNoticePrtCnt": 0,
          "WitmClass1": "PLANNED",
          "WitmClass2": null,
          "WitmClass3": null,
          "WitmClass4": null,
          "WitmVendorCode": null,
          "WitmScheduleDate": "2015-05-27",
          "WitmActiveFlag": "Y",
          "WitmTeamCode": "FIELD",
          "WitmBchNum": null,
          "WitmPostDate": null,
          "WitmSrcCompCode": null,
          "WitmJobCode": null,
          "WitmPhsCode": null,
          "WitmDeptCode": null,
          "WitmPriority": 3,
          "WitmIssueId": null,
          "WitmDeliveryDate": null,
          "WitmAppTypeCode": "PRM",
          "WitmDateCreated": null,
          "WitmCreatedBy": null,
          "WitmDateModified": "2016-03-09T06:52:04Z",
          "WitmModifiedBy": "ADWAIT",
          "WitmScheduleEndDate": null,
          "WitmBillingType": null,
          "WitmSubmittedBillingFlag": null,
          "WitmBillingAmt": null,
          "WitmBillingStateCode": "NR",
          "WitmChargeJobFlag": "N",
          "WitmChargeCompCode": null,
          "WitmChargeJobCode": null,
          "WitmChargePhsCode": null,
          "WitmChargeCatCode": null,
          "WitmUnits": null,
          "WitmWoEntry2Flag": "N",
          "WitmBuildingCode": null,
          "WitmFloorNo": null,
          "WitmRoomNo": null,
          "WitmUserField2": "055033",
          "WitmUserField3": "MAINT",
          "WitmSelectFlag": "N",
          "WitmWoVUuid": "D21723A19CDE5650E05316821FACB6B7",
          "WitmVUuid": "D21729F91C755FB8E05316821FACAF93",
          "WitmIuCreateDate": "2015-05-27T04:19:32Z",
          "WitmIuCreateUser": "BILL",
          "WitmIuUpdateDate": "2016-03-09T06:52:04Z",
          "WitmIuUpdateUser": "ADWAIT",
          "links": [
            {
              "rel": "self",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C755FB8E05316821FACAF93",
              "name": "prmworkitem",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C755FB8E05316821FACAF93",
              "name": "prmworkitem",
              "kind": "item"
            }
          ]
        },
        {
          "WitmWorkItemType": "EQ",
          "WitmTaskCode": "02",
          "WitmTaskPtgtType": "CL",
          "WitmTgtType": "EQ",
          "WitmWoCompCode": "001",
          "WitmWoCode": "PWOYY.002",
          "WitmLineNumber": 1,
          "WitmWoStepTitle": "B 500 Hr Service",
          "WitmWoStepDescription": "CHG. HYDRAULIC FILTER               SMCS Code: CT308274COOLING SYSTEM FLUSH               SMCS Code: 1350-044",
          "WitmDeadlineDate": "2015-05-27",
          "WitmThresholdDate": "2015-05-27",
          "WitmRecurringFlag": "1",
          "WitmDeadlineReading": 500,
          "WitmMissedTaskCount": 0,
          "WitmAcumTypeCode": "HR",
          "WitmJcatLabCompCode": null,
          "WitmJcatLabJobCode": null,
          "WitmJcatLabPhsCode": null,
          "WitmJcatLabourCode": null,
          "WitmJcatPartsCompCode": null,
          "WitmJcatPartsJobCode": null,
          "WitmJcatPartsPhsCode": null,
          "WitmJcatPartsCode": null,
          "WitmJcatConCompCode": null,
          "WitmJcatConJobCode": null,
          "WitmJcatConPhsCode": null,
          "WitmJcatContractorCode": null,
          "WitmJcatEqCompCode": null,
          "WitmJcatEqJobCode": null,
          "WitmJcatEqPhsCode": null,
          "WitmJcatEquipmentCode": null,
          "WitmJcatOthCompCode": null,
          "WitmJcatOthJobCode": null,
          "WitmJcatOthPhsCode": null,
          "WitmJcatOtherCode": null,
          "WitmWiccCompCode": null,
          "WitmWiccLabourCode": null,
          "WitmWiccPartsCode": null,
          "WitmWiccContractorCode": null,
          "WitmWiccEquipmentCode": null,
          "WitmWiccOtherCode": null,
          "WitmStatus": "C",
          "WitmComments": null,
          "WitmCompletionDate": "2016-03-09",
          "WitmCompletionReading": 2632,
          "WitmNoticePrtCnt": 0,
          "WitmClass1": "PLANNED",
          "WitmClass2": null,
          "WitmClass3": null,
          "WitmClass4": null,
          "WitmVendorCode": null,
          "WitmScheduleDate": "2015-05-27",
          "WitmActiveFlag": "Y",
          "WitmTeamCode": "FIELD",
          "WitmBchNum": null,
          "WitmPostDate": null,
          "WitmSrcCompCode": null,
          "WitmJobCode": null,
          "WitmPhsCode": null,
          "WitmDeptCode": null,
          "WitmPriority": 3,
          "WitmIssueId": null,
          "WitmDeliveryDate": null,
          "WitmAppTypeCode": "PRM",
          "WitmDateCreated": null,
          "WitmCreatedBy": null,
          "WitmDateModified": "2016-03-09T06:52:43Z",
          "WitmModifiedBy": "ADWAIT",
          "WitmScheduleEndDate": null,
          "WitmBillingType": null,
          "WitmSubmittedBillingFlag": null,
          "WitmBillingAmt": null,
          "WitmBillingStateCode": "NR",
          "WitmChargeJobFlag": "N",
          "WitmChargeCompCode": null,
          "WitmChargeJobCode": null,
          "WitmChargePhsCode": null,
          "WitmChargeCatCode": null,
          "WitmUnits": null,
          "WitmWoEntry2Flag": "N",
          "WitmBuildingCode": null,
          "WitmFloorNo": null,
          "WitmRoomNo": null,
          "WitmUserField2": "055033",
          "WitmUserField3": "MAINT",
          "WitmSelectFlag": "N",
          "WitmWoVUuid": "D21723A19CDE5650E05316821FACB6B7",
          "WitmVUuid": "D21729F91C765FB8E05316821FACAF93",
          "WitmIuCreateDate": "2015-05-27T04:19:32Z",
          "WitmIuCreateUser": "BILL",
          "WitmIuUpdateDate": "2016-03-09T06:52:43Z",
          "WitmIuUpdateUser": "ADWAIT",
          "links": [
            {
              "rel": "self",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C765FB8E05316821FACAF93",
              "name": "prmworkitem",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem/D21729F91C765FB8E05316821FACAF93",
              "name": "prmworkitem",
              "kind": "item"
            }
          ]
        }
      ],
      "count": 5,
      "hasMore": true,
      "limit": 5,
      "offset": 0,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/prm-rest-api/rest/1/prmworkitem",
          "name": "prmworkitem",
          "kind": "collection"
        }
      ]
    }
    object