Also, noticed a bit odd scenario where if the property name is "tags" , then the same query is not working whereas same query with any other custom property e.g. messages/abc etc.. is working fine.Is there any default constraint that any custom multivalued property named as "tags" should not be cons...

Updated: Thank you Arun. Yes, it worked fine for the single value in the multi valued attributes.

UPDATED: Thank you Debal for sharing the information. This looked fine for me; I was having a typo earlier with duplicated string value and hence, was facing the same. thanks!

I’m trying to build a SQL2 Query where I want to search a String value within a multivalued property.e.g. something similar to this —>   SELECT * FROM [nt:unstructured] AS node WHERE ISDESCENDANTNODE(node,’/content/a/b/c’) AND CONTAINS(node.[MULTI_PROP], ‘hello’);Here MULTI_PROP is a String[ ] prope...