Expand my Community achievements bar.

SOLVED

SQL 2 Query for full text search.

Avatar

Level 4

Need SQL2 Query for full text search .Do not want to use query builder.Please help me for the same.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hey Suresh,

Have you looked at awesome post by:

http://labs.6dglobal.com/blog/2014-10-07/9-jcr-sql-2-queries-every-aem-dev-should-know/

They provide an example:

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.title, 'client')

(try to replace s.title with s.*)

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.*, 'client')

Thanks,

Peter

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

Hey Suresh,

Have you looked at awesome post by:

http://labs.6dglobal.com/blog/2014-10-07/9-jcr-sql-2-queries-every-aem-dev-should-know/

They provide an example:

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.title, 'client')

(try to replace s.title with s.*)

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.*, 'client')

Thanks,

Peter

Avatar

Administrator

Hi 

Please have a look at this article, this is good read.

Link:- http://labs.6dglobal.com/blog/2014-10-07/9-jcr-sql-2-queries-every-aem-dev-should-know/ (9 JCR-SQL2 Queries Every AEM Developer Should Know)

I hope this would help you.

Thanks and Regards

Kautuk Sahni



Kautuk Sahni

Avatar

Level 5

FYI since labs.6dglobal.com is down, here is the same post on JCRSQL2 queries on my personal blog:

https://www.danklco.com/posts/2014/10/07/9-jcr-sql-2-queries-every-aem-dev-should-know/