Services Integration Framework Guide

10.4 HotFix 3
- 10.5
- 10.4 HotFix 2
- 10.4 HotFix 1
- 10.4
- 10.3 HotFix 3
- 10.3 HotFix 2
- 10.3 HotFix 1
- 10.3

Back Next

SearchQuery<Resource Name>

The

SearchQuery<Resource Name>

request searches for records in a package based on an SQL condition clause. The condition clause can reference any columns in the package and can use operators that the target database supports. The response contains matching records.

To perform a search that is not case sensitive, set the

case.insensitive.search

property in the

cmxserver.properties.xml

file to true, and use the

SearchQuery<Resource Name>

request to specify a search criterion, such as lower(name)=lower('Jim').

Usage Example

The following sample code uses the SOAP protocol to call the

SearchQuery<Resource Name>

request:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:datastewarddemo.siperian.api" xmlns:urn1="urn:siperian.api">
   <soapenv:Header/>
   <soapenv:Body>
      <urn:searchQueryPkgParty>
         <!--Optional:-->
         <urn1:username>admin</urn1:username>
         <!--Optional:-->
         <urn1:password>
            <urn1:password>admin</urn1:password>
            <urn1:encrypted>false</urn1:encrypted>
         </urn1:password>
         <urn1:orsId>localhost-orcl-DS_UI1</urn1:orsId>
         <urn:recordsToReturn>10</urn:recordsToReturn>
         <urn:returnTotal>true</urn:returnTotal>
         <!--Zero or more repetitions:-->
         <urn:pkgParty>
            <!--Optional:-->
            <urn:displayName>ELIEZER MENDEZ</urn:displayName>
         </urn:pkgParty>
      </urn:searchQueryPkgParty>
   </soapenv:Body>
</soapenv:Envelope>

The following sample code displays the response to the

SearchQuery<Resource Name>

request:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <searchQueryPkgPartyReturn xmlns="urn:datastewarddemo.siperian.api">
         <ns1:message xmlns:ns1="urn:siperian.api">The SEARCH QUERY REQUEST was processed successfully</ns1:message>
         <pkgParty>
            <rowidObject>173</rowidObject>
            <displayName>ELIEZER MENDEZ</displayName>
            <partyType>Person</partyType>
         </pkgParty>
         <recordCount>1</recordCount>
      </searchQueryPkgPartyReturn>
   </soapenv:Body>
</soapenv:Envelope>

Rename Saved Search

Table of Contents

Services Integration Framework Guide

Services Integration Framework Guide

SearchQuery<Resource Name>

SearchQuery<Resource Name>

Usage Example