Is there a way to combine NOT clause in search?

[chetanvajre2014]

For example

we want to search a text "ABC" in a property but exclude the results if the result has "XYZ" in same property (while doing full text)

[smacdonald2008]

I would look at using JCR SQL/2 to perform this and using NOT. There are great online resources for this.

https://docs.jboss.org/jbossdna/0.7/manuals/reference/html/jcr-query-and-search.html#d0e7897

https://wiki.magnolia-cms.com/display/WIKI/JCR+Query+Cheat+Sheet

http://labs.6dglobal.com/blog/2014-10-07/9-jcr-sql-2-queries-every-aem-dev-should-know/

[Kunal_Gaba_]

Check the following examples- http://aemtipsandtricks.blogspot.com/2014/07/structuring-content-for-faceted.html

The unequals operator can be used in this case. 

Unequals (Not equals)
1_property.operation=unequals
1_property=jcr:title
1_property.value=Apples