Content SQL query doesn't return results
上次更新時間 Apr 29, 2021 03:43:53 PM GMT | 亦適用於 Communiqué 4
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%'
Run the query as follows:
SELECT * FROM /content/app/myapp WHERE ArticleEntry.*.PublicationDate like '%2008%'
This issue is a limitation of the lucene-based query implementation in CQ. It does not index the name of the container (-> 'Single').