AND constraint on a tree, result of path traversing on a One-to-Many entities,


#1

I am looking for a set of entries of BillingAccounts using path traversing on it’s dependencies, here, serviceAgreements and then servicePoints, with the following constraint:

one of it’s entries contains ‘5G’ AND one of it’s entries contains ‘5E’

BillingAccount.fetchCount({filter:"contains(serviceAgreements.servicePoints.id, '5G') && contains(serviceAgreements.servicePoints.id, '5E')"})
This one yields a zero, obviously, as it looks for the same AND constraint on every combination.