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

Avatar

Avatar

edubey

Avatar

edubey

edubey

17-01-2018

Can you share the query where you used like clause ?

Avatar

Avatar

BigT168

Avatar

BigT168

BigT168

17-01-2018

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

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Reply

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Reply

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