Jump to

• Request
• Response
• Examples

Get Saved Searches

get

/rest/v19/searchResources/{resourceVarName}

Use this endpoint to retrieve a list of saved searches for the specified resource.

Request

Path Parameters

• resourceVarName(required): string
  The unique variable name to identify the process.

Query Parameters

• limit: integer
  The pagination limit.
• offset: integer
  The pagination offset.
• showAll: string
  Parameter specifying whether to show all searches or the hidden ones

  Allowed Values: [ "ALL", "HIDDEN", "VISIBLE", "INACTIVE" ]

Back to Top

Response

Default Response

The response for getting the saved searches.

Body ()

Root Schema : SavedSearchItemModelResponse

Type: object

Show Source

• count: integer
• hasMore: boolean
  Default Value: false
• items: array items
• limit: integer
• links: array links
• offset: integer
• totalResutls: integer

{
    "type":"object",
    "properties":{
        "limit":{
            "type":"integer"
        },
        "offset":{
            "type":"integer"
        },
        "totalResutls":{
            "type":"integer"
        },
        "count":{
            "type":"integer"
        },
        "hasMore":{
            "type":"boolean",
            "default":false
        },
        "items":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/savedSearchItem"
            }
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/link"
            }
        }
    }
}

Nested Schema : items

Type: array

Show Source

• Array of: object savedSearchItem

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/savedSearchItem"
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object reference links
  Title: reference links

  Reference links for the Parent, Self, Children and Related as applicable

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/link"
    }
}

Nested Schema : savedSearchItem

Type: object

Show Source

• active: boolean
• aggregations: object SavedSearchGroupByModel
• default: boolean
• deletable: string
• description: string
  Example: This is a dummy description
• fields: array fields
• hidden: boolean
• links: array links
• mongoQuery: object mongoQuery
  Additional Properties Allowed: additionalProperties
• name: string
  Example: savedSearchDummy
• orderBy: array orderBy
• queryUuid: number
• savedSearchNumber: number
• searchType: string
  Allowed Values: [ "_user_defined_search", "_my_quotes_search", "_my_approval_search" ]
• shared: boolean
• siteLevelDefault: boolean
• updatable: boolean
• userId: number
• userKey: string
• userLevelDefault: boolean
• userName: string

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string",
            "example":"savedSearchDummy"
        },
        "description":{
            "type":"string",
            "example":"This is a dummy description"
        },
        "queryUuid":{
            "type":"number"
        },
        "savedSearchNumber":{
            "type":"number"
        },
        "default":{
            "type":"boolean"
        },
        "updatable":{
            "type":"boolean"
        },
        "userId":{
            "type":"number"
        },
        "userName":{
            "type":"string"
        },
        "fields":{
            "type":"array",
            "items":{
                "type":"string"
            }
        },
        "shared":{
            "type":"boolean"
        },
        "active":{
            "type":"boolean"
        },
        "searchType":{
            "type":"string",
            "enum":[
                "_user_defined_search",
                "_my_quotes_search",
                "_my_approval_search"
            ]
        },
        "mongoQuery":{
            "type":"object",
            "additionalProperties":{
            }
        },
        "orderBy":{
            "type":"array",
            "items":{
                "type":"string",
                "example":"_id:desc"
            }
        },
        "siteLevelDefault":{
            "type":"boolean"
        },
        "userLevelDefault":{
            "type":"boolean"
        },
        "hidden":{
            "type":"boolean"
        },
        "userKey":{
            "type":"string"
        },
        "deletable":{
            "type":"string"
        },
        "aggregations":{
            "$ref":"#/definitions/SavedSearchGroupByModel"
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/link"
            }
        }
    }
}

Nested Schema : SavedSearchGroupByModel

Type: object

Show Source

• attribute: string
• sort: string
  Default Value: desc

  Allowed Values: [ "asc", "desc" ]

{
    "type":"object",
    "properties":{
        "attribute":{
            "type":"string"
        },
        "sort":{
            "type":"string",
            "enum":[
                "asc",
                "desc"
            ],
            "default":"desc"
        }
    }
}

Nested Schema : fields

Type: array

Show Source

• Array of: string

{
    "type":"array",
    "items":{
        "type":"string"
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object reference links
  Title: reference links

  Reference links for the Parent, Self, Children and Related as applicable

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/link"
    }
}

Nested Schema : mongoQuery

Type: object

Additional Properties Allowed

Show Source

{
    "type":"object",
    "additionalProperties":{
    }
}

Nested Schema : orderBy

Type: array

Show Source

• Array of: string
  Example: _id:desc

{
    "type":"array",
    "items":{
        "type":"string",
        "example":"_id:desc"
    }
}

Nested Schema : reference links

Type: object

Title: reference links

Reference links for the Parent, Self, Children and Related as applicable

Show Source

• href: string
  Title: URL to the related object

  URL to the related object
• name: string
• rel: string
  Title: Link Relationship to the current object

  Default Value: self

  Link Relationship to the current object

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string",
            "description":"Link Relationship to the current object",
            "title":"Link Relationship to the current object",
            "default":"self"
        },
        "href":{
            "type":"string",
            "description":"URL to the related object",
            "title":"URL to the related object"
        },
        "name":{
            "type":"string"
        }
    },
    "title":"reference links",
    "description":"Reference links for the Parent, Self, Children and Related as applicable"
}

Back to Top

Examples

The following example shows how to retrieve a list of saved searches for the specified resource by submitting a GET request to the REST resource using cURL. For more information about cURL, see Use cURL.

curl -X GET -H "Authorization: Bearer <token>" -H "Accept: application/json"
https://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction

Response Body Sample

{
  "items": [{
      "_entity": "Quote",
      "name": "My Approval Search",
      "description": "Search will return list of transactions which requires approval of logged in user",
      "updatable": false,
      "deletable": false,
      "queryUuid": 36933891,
      "savedSearchNumber": 36933891,
      "default": false,
      "shared": true,
      "active": true,
      "userId": -1,
      "fields": [
        "owner_t",
        "createdDate_t",
        "transactionID_t",
        "_customer_t_company_name",
        "lastUpdatedDate_t",
        "transactionName_t",
        "status_t",
        "totalContractValue_t",
        "totalAnnualValue_t",
        "totalOneTimeDiscount_t",
        "totalOneTimeNetAmount_t",
        "totalMonthlyListAmount_t",
        "lastPricedDate_t",
        "priceWithinPolicy_t",
        "version_number_versionTransaction_t",
        "version_t"
      ],
      "searchType": "_my_approval_search",
      "siteLevelDefault": false,
      "userLevelDefault": false,
      "hidden": false,
      "links": [{
          "rel": "self",
          "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction/36933891",
          "name": "self"
        }, {
          "rel": "canonical",
          "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction/36933891",
          "name": "canonical"
        }, {
          "rel": "parent",
          "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction",
          "name": "parent"
        }
      ]
    }, {
      "_entity": "Quote",
      "name": "Vision Quotes In Process",
      "description": "",
      "updatable": true,
      "deletable": true,
      "queryUuid": 38678835,
      "savedSearchNumber": 38678835,
      "default": false,
      "shared": false,
      "active": true,
      "userId": 4119220,
      "userName": "superuser",
      "userKey": "ecde4a3c-1924-488f-821c-d4defcfafce3",
      "fields": [
        "transactionID_t",
        "version_t",
        "version_number_versionTransaction_t",
        "_customer_t_company_name",
        "transactionName_t",
        "status_t",
        "totalContractValue_t",
        "owner_t",
        "createdDate_t",
        "lastUpdatedDate_t",
        "totalAnnualValue_t"
      ],
      "orderBy": [
        "lastUpdatedDate_t:desc"
      ],
      "mongoQuery": {
        "$and": [{
            "_customer_t_company_name": {
              "$regex": "Vision"
            }
          }, {
            "status_t": {
              "$eq": "OPEN"
            }
          }
        ]
      },
      "searchType": "user_defined_search",
      "siteLevelDefault": false,
      "userLevelDefault": false,
      "hidden": false,
      "links": [{
          "rel": "self",
          "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction/38678835",
          "name": "self"
        }, {
          "rel": "canonical",
          "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction/38678835",
          "name": "canonical"
        }, {
          "rel": "parent",
          "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction",
          "name": "parent"
        }
      ]
    }, {
      "_entity": "Quote",
      "name": "My Quotes",
      "description": "Search will return list of transactions that are modified in the last one year",
      "updatable": false,
      "deletable": false,
      "queryUuid": 38526573,
      "savedSearchNumber": 38526573,
      "default": true,
      "shared": true,
      "active": true,
      "userId": -1,
      "fields": [
        "transactionID_t",
        "version_t",
        "version_number_versionTransaction_t",
        "_customer_t_company_name",
        "transactionName_t",
        "status_t",
        "totalContractValue_t",
        "owner_t",
        "createdDate_t",
        "lastUpdatedDate_t",
        "totalAnnualValue_t"
      ],
      "orderBy": [
        "lastUpdatedDate_t:desc"
      ],
      "mongoQuery": {
        "$and": [{
            "lastUpdatedDate_t": {
              "$gte": "2023-02-26T21:09:51Z"
            }
          }
        ]
      },
      "aggregations": {
        "attribute": "status_t",
        "sort": "desc"
      },
      "searchType": "_my_quotes_search",
      "siteLevelDefault": true,
      "userLevelDefault": false,
      "hidden": false,
      "links": [{
          "rel": "self",
          "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction/38526573",
          "name": "self"
        }, {
          "rel": "canonical",
          "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction/38526573",
          "name": "canonical"
        }, {
          "rel": "parent",
          "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction",
          "name": "parent"
        }
      ]
    }
  ],
  "count": 3,
  "hasMore": false,
  "limit": 10,
  "offset": 0,
  "totalResults": 3,
  "links": [{
      "rel": "self",
      "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction",
      "name": "self"
    }, {
      "rel": "canonical",
      "href": "http://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction",
      "name": "canonical"
    }, {
      "rel": "parent",
      "href": "http://sitename.oracle.com/rest/v19/searchResources",
      "name": "parent"
    }
  ]
}

Back to Top