Limit runtime dropdown choices
I'd like to limit an accounts.account_id runtime filter to only show values where the account belongs to a specific profile. We have a lot of accounts and I'm trying to improve usability of some of our reports by limiting the run-time dropdown for account to only those relevant.
I've tried using table joins to accomplish this, but haven't had any luck. Using an inner join between accounts and profiles doesn't accomplish anything because the accounts are all present in the profiles table. Using an outer join lets me specify a filter, but since it's an outer join (incidents -> accounts -> profiles) the filter is pointless and returns all the accounts.