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?
Can you share the query where you used like clause ?
Can you add one more condition: and not CONTAINS([cq:tags], "global_search_business")