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 onesAllowed Values:
[ "ALL", "HIDDEN", "VISIBLE", "INACTIVE" ]
Response
Default Response
The response for getting the saved searches.
Root Schema : SavedSearchItemModelResponse
Type:
Show Source
object
-
count:
integer
-
hasMore:
boolean
Default Value:
false
-
items:
array items
-
limit:
integer
-
links:
array links
-
offset:
integer
-
totalResutls:
integer
Nested Schema : links
Type:
Show Source
array
-
Array of:
object reference links
Title:
reference links
Reference links for the Parent, Self, Children and Related as applicable
Nested Schema : savedSearchItem
Type:
Show Source
object
-
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
Nested Schema : SavedSearchGroupByModel
Type:
Show Source
object
-
attribute:
string
-
sort:
string
Default Value:
desc
Allowed Values:[ "asc", "desc" ]
Nested Schema : links
Type:
Show Source
array
-
Array of:
object reference links
Title:
reference links
Reference links for the Parent, Self, Children and Related as applicable
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 -
rel:
string
Title:
Link Relationship to the current object
Link Relationship to the current object
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" } ] }