Retrieve JC Combined Job Relations By Code
    • 06 Jan 2025
    • 1 Minute to read
    • Dark
      Light

    Retrieve JC Combined Job Relations By Code

    • Dark
      Light

    Article summary

    Get
    /jc-rest-api/rest/1/jcjobcombinedjobrel

    Query Standards

    Finder

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

    • Select Related Job
    • Select By Dates
    • By UUID

    Recommended finder parameters. Refer to Query Parameters for example.

    ParameterDescriptionSample
    CompCodeRelRelated Company Code20
    JobCodeRelRelated Job Code072017
    JobCodeMainMain Job Code1997
    CompCodeMainMain Company Code10

    Select By Dates

    This is an optional finder for querying Combined Job Relations by Audit Date, .

    ParameterDescriptionSample
    AuditDateCreate or Update Date Time Filter2016-01-01

    By UUID

    This is an optional finder for querying a specific Combined Job Relation by row ID.

    ParameterDescriptionSample
    /VUUIDThe VUuid attribute is the Unique row ID/jc-rest-api/rest/1/jcjobcombinedjobrel/F795E3D99A9B09D1E05313061FACE0E1
    Security
    HTTP
    Type basic

    Basic authentication

    Query parameters
    finder
    string
    ExampleselectRelatedJob;CompCodeRel=20, JobCodeRel=072017, JobCodeMain=1997, CompCodeMain=10
    limit
    integer
    Example500
    offset
    integer
    Example0
    totalResults
    boolean
    ExampleTrue
    orderBy
    string
    ExampleJcrVUuid:desc
    Responses
    200

    OK

    Headers
    Content-Type
    string
    Exampleapplication/vnd.oracle.adf.resourcecollection+json
    {
      "items": [
        {
          "JcrActiveFlag": "Y",
          "JcrCompCodeMain": "10",
          "JcrCompCodeRel": "20",
          "JcrExcBillingFlag": "N",
          "JcrExcContractFlag": "N",
          "JcrExcRevenueFlag": "N",
          "JcrIuCreateDate": "2023-03-23T17:48:53Z",
          "JcrIuUpdateDate": null,
          "JcrJobCodeMain": "1997",
          "JcrJobCodeRel": "072017",
          "JcrJobNameMain": null,
          "JcrJobNameRel": "Hilton Concrete",
          "JcrVUuid": "F795E3D99A9B09D1E05313061FACE0E1",
          "links": [
            {
              "rel": "self",
              "href": "http://solutionsr12mob.cmicpaas.com:80/cmicprod/jc-rest-api/rest/1/jcjobcombinedjobrel/F795E3D99A9B09D1E05313061FACE0E1",
              "name": "jcjobcombinedjobrel",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "http://solutionsr12mob.cmicpaas.com:80/cmicprod/jc-rest-api/rest/1/jcjobcombinedjobrel/F795E3D99A9B09D1E05313061FACE0E1",
              "name": "jcjobcombinedjobrel",
              "kind": "item"
            }
          ]
        }
      ],
      "totalResults": 5,
      "count": 1,
      "hasMore": true,
      "limit": 1,
      "offset": 0,
      "links": [
        {
          "rel": "self",
          "href": "http://solutionsr12mob.cmicpaas.com:80/cmicprod/jc-rest-api/rest/1/jcjobcombinedjobrel",
          "name": "jcjobcombinedjobrel",
          "kind": "collection"
        }
      ]
    }
    object