Search Service using SOAP - multi parameters

We have Category with 5 fields and I want to use Searchservice.svc SOAP to search Category field value.

Example: I want to search for all projects where category value is "001" using SOAP request.

I was able to narrow down my Where1 query to OTSubType = 202 but I also want to add second parameter by Category listed above (see below).

ssr.ResultSetSpec = @where1=("OTSubType"":202+""Attr_4071_3"":""001"")";

Listed query does not return any result, and I know it should return 1 result.

Thank you inadvance for your help,

Find more posts tagged with

Comments

appuGmail

From what the dev world has been told there might be every few updates to the search service SOAP most of us will use the search XML API I think it also works with REST.

Having said that any viable query that you can run through the GUI should also work in SOAP for the most part.

I would use the GUI in your search and see what makes it work, then you can turn search logging and capture the query for your program.

Ciao,

..... appnair appunair( Livelink Rocks )

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Thu, Feb 14, 2019 at 8:14 AM eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

Search Service using SOAP - multi parameters Posted byloren.e.pettijohn.civ@mail.mil (Pettijohn, Loren)On 02/14/2019 09:11 AM

We have Category with 5 fields and I want to use Searchservice.svc SOAP to search Category field value.Example: I want to search for all projects where category value is "001" using SOAP request.I was able to narrow down my Where1 query to OTSubType = 202 but I also want to add second parameter by Category listed above (see below).ssr.ResultSetSpec = @where1=("OTSubType"":202+""Attr_4071_3"":""001"")";Listed query does not return any result, and I know it should return 1 result.Thank you inadvance for your help,
[To post a comment, use the normal reply function]
Forum: Content Server Development Forum
Content Server: My Support

Bickers

Hi Loren,

Try changing your ResultSetSpec to:

ssr.ResultSetSpec = @where1=("OTSubType"":202 AND ""Attr_4071_3"":""001"")" + "&lookfor1=complexquery";

With recent versions of the search syntax, we have to specify that this is a complex type of query (as in the Classic UI advanced search page).

Regards,

Phil.

From: eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com>
Sent: 14 February 2019 14:36
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: [EXTERNAL] - Re Search Service using SOAP - multi parameters

[EXTERNAL] - Re Search Service using SOAP - multi parameters

Posted byappnair@gmail.com (Nair, Krishnankutty) On 02/14/2019 09:36 AM