I tried doing as suggested with the below. It keeps searching and nothing is happening after that. path=/content nodename=*archive* Will explore the suggested documentation on predicates. Thanks so much for the response

Thanks to all of you who provided answers. Each of the answer helped me to learn something new, really appreciate it for taking the time and effort to reply  

I want to do a tree activation of pages under a certain /content path. But one requirement is that I want to be able to exclude pages that has a certain text in the page name and publish all the remaining pages. For example, if a page's name contains the text 'archive', i don't want to publish those...

I have a lot of pages under /content path that has names like archive, archive1, archive-test, test-archive, etc.I tried using the below Query Builder queries but it doesn't seem to work. path=/contentnodename=archive (and) type=cq:Pagepath=/contentgroup.property=nodenamegroup.property.value=archive...