You need to create a condition on the accounts model that does the subquery condition so only accounts with opportunities that are owned by the user name.  Both the primary condition and the subcondition should be filterable default off. 

Then in your mobile page add a button somewhere that activates both of these conditions and requeries the model. 

Then sit back and enjoy your handiwork! 

---

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 Subcondition Logic value on this Condition is blank. nBTW: I have yet to find a definition for this field. What does it do? How is it used?]
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?

---