Content SQL query doesn't return results

Issue

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').

 Adobe

Saage abi kiiremini ja hõlpsamalt

Uus kasutaja?

Adobe MAX 2024

Adobe MAX
Loovuse konverents

14.–16. oktoobril Miami Beachis ja veebis

Adobe MAX

Loovuse konverents

14.–16. oktoobril Miami Beachis ja veebis

Adobe MAX 2024

Adobe MAX
Loovuse konverents

14.–16. oktoobril Miami Beachis ja veebis

Adobe MAX

Loovuse konverents

14.–16. oktoobril Miami Beachis ja veebis