Content SQL query doesn't return results

A search query doesn't return any results. You are running your search on handles that the Lucene indexer (full text) indexed.

For example, the following query doesn't return any results:

SELECT * FROM /content/app/myapp WHERE ArticleEntry.Single.PublicationDate like '%2008%'

Solution

Run the query as follows:

SELECT * FROM /content/app/myapp WHERE ArticleEntry.*.PublicationDate like '%2008%'

Additional information

This issue is a limitation of the lucene-based query implementation in CQ. It does not index the name of the container (-> 'Single').