Query that exclude documents of ResultSetSpec SingleSearchRequest

Roldan Ortiz Molinares

Hi all!

Hey anybody know how since query exclude documents that contain the word "Alfa"?

SingleSearchRequest singleSearchRequest = new SingleSearchRequest(); 

singleSearchRequest.setDataCollectionSpec("'LES Enterprise'"); 

singleSearchRequest.setQueryLanguage("Livelink Search API V1"); 

singleSearchRequest.setFirstResultToRetrieve(1); 

singleSearchRequest.setNumResultsToRetrieve(100); 

singleSearchRequest.setResultOrderSpec("sortByRegion=OTSubType&sortDirection=ascending"); 

singleSearchRequest.setResultSetSpec("where1=(\"OTSubType\":144) AND where=NOT("Alfa")");

 

singleSearchRequest.getResultTransformationSpec().add("OTName");

singleSearchRequest.getResultTransformationSpec().add("OTDataID");

singleSearchRequest.getResultTransformationSpec().add("OTFileType");

singleSearchRequest.getResultTransformationSpec().add("OTLocation");

 

Thx 4 advance!