...can sometimes not work.

allContentTypes:content-type.Academie AND (-(allContentTypes:content-type.AbstractRefTable))

does not return any result.

allContentTypes:content-type.Academie AND (*:* -(allContentTypes:content-type.AbstractRefTable))

does.

I think we should have a tour of implementations of org.ametys.cms.search.query.Query and replace in #build methods "-" by "*:* -"

See also CMS-7940
See also ContentTypeQuery#build, NotQuery#build and DocumentTypeQuery which are already fixed