How would you set up these filters? I have a set of master records (in a custom object), and some have child detail relationships (to another custom object) and some do not. I want the report, by default, to list only the masters that have details.
Presumably, the conditions referred to previously would be default ON, but my subquery is filtering out all of the master records.
My model is based on the Parent__c object and contains the fields Name and Id.
The model also includes the child relationship Child__r.
The Child__r “field” includes Parent__c, Name, and Id.
Child__r also includes Active__c, which is used in the child field Conditions as = true.
Child__r also includes Childs_Name__c, which is used in the child field Properties to order by.
The model itself has one Condition, described in the builder as…
- Parent__c records where Name
-
is in the set of values
- specified by returning Parent__c values from a subquery on the Child__c object
- This condition is always on
The Condition does not have any Sub-Conditions. (Presumably, the “active” condition is defined in the child Conditions. Repeating the same condition in the subquery appears redundant - and was ineffective when I tried it.)
The groups of detail records display nicely “under” their respective master records without the subquery condition. But how do I get rid of the master records that do not have any active children?