Hi,
My requirement is to find all the pages with a particular property being multi-valued i.e. I want to find all the pages with property type as String[] using SQL2 query.
Regards,
Shallu
Views
Replies
Total Likes
Hi,
Do you know the name of your property?
Is it always multi-value?
If yes, just search for nodes with your property name
Example: SELECT * FROM [cq:PageContent] AS s WHERE ISDESCENDANTNODE([/content/geometrixx-outdoors]) and [jcr:mixinTypes] is not null
Views
Replies
Total Likes
Hi Anton,
Actually property value can be single values(String) or multi-valued(String[]), that's where I need to find all the nodes where property value is multi-valued.
Views
Replies
Total Likes
AFAIK there is no way to find only String[] properties. I suggest to use Sling / JCR API to execute query and find all nodes with your property and then iterate through result and filter multi-valued properties.
Views
Replies
Total Likes
Agreed - for this - look like you will ahve to interate through the result set to seek what you are looking for.
Views
Replies
Total Likes
Views
Likes
Replies