Level 4

Solved

SQL 2 Query for full text search.

5 replies
6355 views
Translate

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

Peter_PuzanovsAccepted solution

New Participant

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

dan_klco

Level 4

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/

Translate

K

Kamaraj_AEM

Level 2

Here is the updated Link:

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

Translate

kautuk_sahni

Employee

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

Translate

Kautuk Sahni

Peter_PuzanovsAccepted solution

New Participant

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

Translate

Lokesh_Shivalingaiah

Level 10

you can use 'CONTAINS' to do that full text search. refer [1] and it gives an idea about it

[1] https://docs.jboss.org/jbossdna/0.7/manuals/reference/html/jcr-query-and-search.html#jcr-sql2-full-text-search-constraints

Translate

Sign up

Login with SSO

Login to the community

Login with SSO