Need SQL2 Query for full text search .Do not want to use query builder.Please help me for the same.
解決済! 解決策の投稿を見る。
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
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
you can use 'CONTAINS' to do that full text search. refer [1] and it gives an idea about it
表示
返信
いいね!の合計
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
表示
返信
いいね!の合計
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/
Here is the updated Link:
https://danklco.com/posts/2014-10-9-jcr-sql-2-queries-every-aem-dev-should-know/
表示
返信
いいね!の合計