Search Service Where Clause

NidhiJ

I am using Search Service to get the documents in a result set.

singleSearchRequest.setResultSetSpec("where=\"OTSubType\":144");

I need to add following conditions to the where clause, but dont know how to frame the query:

1. Get all the documents within creation date range

AND

2. Get all the documents where a custom attribute say type = HRDocument

AND

3. Category applied is not equal to 'HR Info' category

Find more posts tagged with

Comments

eLink User

Do you have access to a livelink webgui or a friendly LL Admin? Then all you have to do is go to the GUI and perfect a advanced search yes using the GUI.

If it works then make that client LL server do wantsearchlogs=true and re-do the search you will find the search query and its syntax.With some work you can cut and paste into your SOAP code.

A better alternative is to use the REST token if you have to execute the more powerful searchAPI.

This is the Prog Guide it has examples

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objid=60993827&objaction=location&nexturl=%2Fknowledge%2Fcs%2Edll%3Ffunc%3Dsrch%2ESearchCache%26cacheId%3D%3F

another olden days example

http://www.tek-tips.com/faqs.cfm?fid=3552

.....appu appnair appunair

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

On Wed, Feb 3, 2016 at 11:16 AM, eLink Entry: Content Web Services Forum <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

Search Service Where Clause Posted byJayas, NidhiOn 02/03/2016 12:11 PM

I am using Search Service to get the documents in a result set.singleSearchRequest.setResultSetSpec("where=\"OTSubType\":144");I need to add following conditions to the where clause, but dont know how to frame the query:1. Get all the documents within creation date rangeAND2. Get all the documents where a custom attribute say type = HRDocumentAND3. Category applied is not equal to 'HR Info' category
[To post a comment, use the normal reply function]
Forum: Content Web Services Forum
Content Server: Knowledge Center

NidhiJ

I tried below, but not getting the required results. Can someone validate the syntax?

I want to exclude the documents which have category (HR Info with ID 45452) already applied to them.

Say HR Info --> OTDCategory= 45452

singleSearchRequest.setResultSetSpec("where1=(\"OTSubType\":144 AND NOT(\"OTCategory\":45452) AND (\"OTCreateDate\":>20160119 AND \"OTCreateDate\":<20160121)");