Query[SQL/SQL2/Xpath/JCR] to be used to get the required data?

[askdctm]

Hi All,

There are multiple pages in author under /content. Suppose each page has a property as below :

Name    Type      Value
Custom  String[]  old:asdf,old:qwer,new:hjkl

NOTE : There are hundreds of property values which starts with "old:" notation

Suppose, I want to find out all the pages, which has old:xxx[where xxx represents some value present]
as a value in 'Custom' property. 

Probably a query[JCR/Xpath/SQL/SQL2 has to be run to find this out]. Not sure which one is the most efficient here.

Can you please provide me with the query that can be used to find out the results.

Any thoughts on this will be really helpful.

[jura_khrapunov · Accepted solution]

SQL2:

SELECT * FROM [nt:unstructured] WHERE ISDESCENDANTNODE('/content') AND Custom = 'old:xxx'

[askdctm]

Hi Jura,

Thank you for your reply.

[askdctm]

Hi All,

Can you please let me know which is more efficient of the below two queries.

SELECT * FROM [nt:unstructured] WHERE ISDESCENDANTNODE('/content') AND CONTAINS(Custom, 'old:')

SELECT * FROM [nt:unstructured] WHERE ISDESCENDANTNODE('/content') AND Custom like 'old:%'