@Vijayalakshmi_S , Thanks for reply. Please my inline comments : your existing query (original query) : SELECT * FROM [nt:base] AS s WHERE (ISDESCENDANTNODE(s, [/etc/commerce/products/myProject/en/devices])) and s.availabilityStatus = 'Sellable'additional filter that you are referring to (which res...