"Match any" doesn't work when create Search template
When we create Search template, we used "match any" to define "condition A OR condition B" search. But the search results was incorrect. we try to check the query on DB side and found the query used AND not OR.
whenever you use the Contains operator, you are performing a text search on an indexed property. Text search criteria, whether it be for all indexed content (specified by the "Find items with the following terms" field) or specific properties using Contains, are always joined by AND with property criteria. This is why the query's WHERE clause in your first example is t.[DocumentType] LIKE '%Notice%' AND Contains(*, 'DocumentTitle:\.doc', 'Lucene'). When you use the Like operator for both conditions, you are searching purely with property criteria and that is joined by either "AND" or "OR" depending on the property option you selected.