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!
