I have a query where I select nodes of a type based on values in some child nodes of those nodes, thus I use a isdescendantnode. This causes some entries to be returned twice in the results, if those nodes have multiple children where some children meet the first criteria, and some the other.
Is there a way to avoid this by using a different query? select asset.* from [ka:asset] as asset inner join [ka:asset] as agreement on isdescendantnode(agreement, asset) where agreement.[ka:assetType] = 'agreement' and asset.[ka:assetType] = 'company' and (agreement.[ka:owner] = '5e9d5632-c219-44bd-b6e1-f96e9f3ff37e' or agreement.[ka:owner] = '731f35f6-e205-4a53-8ca8-144a6f7dec26') -- -Tor
