Highlighted

jcr-sql2 query starting with specific string

Avatar

Avatar

cqvoyager

Avatar

cqvoyager

cqvoyager

17-01-2018

Hello Team,

In the jcr-sql2 query, is there any way to query the property having the value starts with certain string. 

I have overlapping tags, business:Finance, business:Insurance and global_search_business:Finance, global_search_business:Insurance. I want to only query the content tagged with all business: tags(but not global_search_business: tags).

SELECT * FROM [cq:PageContent] as node WHERE ISDESCENDANTNODE(node, '/content/geometrixx/en/news') AND CONTAINS([cq:tags], "business:") returning the content tagged with both.

I tried CONTAINS([cq:tags], "^business:"), its giving syntax error.

Even I tried LIKE, but no success.

Any suggestions please?

Best Regards,

Durga

Replies

Highlighted

Avatar

Avatar

edubey

Total Posts

1.5K

Likes

264

Correct Answer

392

Avatar

edubey

Total Posts

1.5K

Likes

264

Correct Answer

392
edubey

17-01-2018

Can you share the query where you used like clause ?

Highlighted

Avatar

Avatar

BigT168

Avatar

BigT168

BigT168

17-01-2018

Can you add one more condition: and not CONTAINS([cq:tags], "global_search_business")

Highlighted

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K
smacdonald2008

17-01-2018

Here is a good source of JCR SQL2 examples that may help you.

JCR Query Cheat Sheet - Community Wiki - Magnolia

Hope this helps...