AND condition not working in Content Server Search API as expected

Pratik_Vishwakarma

Hi,

When I am consuming Content Server Search API in SOAP UI, it does not give an expected result when "AND" condition is used,

"Enterprise"
1
10

Livelink Search API V1

sortByRegion=OTModifyDate

where1="Attr_594595_2":"New" and "OTSubType":"144"

OTDataID

Search result seems to be working fine when "AND" condition is removed and service is invoked

eg :
where1="OTSubType":"144"
where1="Attr_594595_2":"New"

Content Server version used is 16.2.8

Hans_Giger

Hi,
It's mandatory to use complex query mode (lookfor1=complexquery) to make sure that operators like AND OR NOT are not handled as search terms.

The behavior was changed in Content Server version 16.2.1 and 16.2.2 as mentioned in the release notes:

Changes – 16.2.2 (September 2017)
2.9.3 Search Query Language
...
The behavior when searching for “any words” or “all words” in advanced search has been changed to ignore Boolean operators (such as “and”, “or”, “not”) and treat them as keywords. This makes the behavior consistent with other search operators. Depending on configuration, this may also change the default search bar behavior.

Changes – 16.2.1 (June 2017)
2.10.9 Search Query Parser
Previously, when using “any words” or “all words” mode in the full text component of advanced search, the words “IN”, “NOT” and “NOT IN” were treated as search operators. This has been corrected, and they are now treated as words. This may affect the interpretation of some existing saved queries.

Regards
Hans