JCR SQL2 query to find multi-value property with duplicate values?

Avatar

Avatar

EricES

Avatar

EricES

EricES

26-09-2018

Is there a way to construct a SQL2 query that would find a multi-value property containing duplicate values?


For instance, we have a multi-value String property called "language". Can a SQL2 query find a node which contains two or more instances of 'en' (English) in the "language" property?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Arun_Patidar

MVP

Total Posts

3.0K

Likes

1.1K

Correct Reply

859

Avatar

Arun_Patidar

MVP

Total Posts

3.0K

Likes

1.1K

Correct Reply

859
Arun_Patidar
MVP

26-09-2018

There is no count(*) or group by selector in JCR SQL , XPath [2] or JCR-SQL2/AQM [3].

So you can't do it with SQL2 query but you can run query like below to find all the nodes with 'en' and then again query each node to check duplicate value using Node API

example -

SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/AEM63App/fr]) and CONTAINS(s.language, 'en')

Answers (0)